Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > 长期使用中型Access数据库的一点经验与缺点

长期使用中型Access数据库的一点经验与缺点

WBOY
Release： 2016-06-07 18:07:32
Original
1277 people have browsed it

长期使用中型Access数据库的一点经验与缺点

Access数据库在用的过程中, 经常不断的进行删除和增加记录的操作,会出现以下问题:
1. 可能会使Update语句更新失败, 明明一条记录存在, 也可以select到,但在用Update时出现找不到记录, 更新失败的错误信息.
2. 会使数据库增大, 并且降低数据库操作的效率
3. 在删除记录时也不会减少数据库的大小, 并且没有可以改善数据库的相应语句

解决办法

下载Access数据库, 用Access软件打开, 并用"修复和压缩数据库"工具进行处理, 保存后再重新上传并覆盖掉原来的数据库即可解决以上的所有问题. 这种办法比较只适合于中小型的数据库, 大的如果采用上下载的办法太慢了.

Related labels：
长期使用中型Access数据库的一点
source：php.cn
Previous article：MySQL ORDER BY 的实现分析 Next article：mysql数据库插入速度和读取速度的调整记录
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to customize HTML code to quickly modify content I have created a website where I want to constantly modify data. This means adding more te...
From 2024-04-04 21:08:14
0
1
3462
How to search title and use another column to check uniqueness I have some scraped product data in the database and I want to use it on my website. I wan...
From 2024-04-02 21:49:55
0
1
375
PHP OOP - Return result of $obj->get() and $obj->get()->count() without calling another method It's hard to explain exactly what I want, but I have to try... LaravelEloquent inspired me...
From 2024-04-01 12:28:10
0
1
401
After copying website to local, WordPress homepage redirects to duplicate copy Background: I have multiple websites running on rpi4 using nginx and wordpress. I want to ...
From 2024-03-31 15:26:18
0
2
280
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template