General discussion

Locked

Enhance performance

By ila97 ·
Currently 1 have 20 years data in my database which had cause my application to run very slow. How do I go about it?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Enhance performance

by Mozster In reply to Enhance performance

Which database software are you using?
If its Access then use the Compact utility to defrag the database into a new file which will make a big difference.
Any other DB software you should be checking the help files for some sort of PACK/COMPRESS tool.

Collapse -

Enhance performance

by ila97 In reply to Enhance performance

I'm using Informix database ... I've read something on update statistics but not very sure about it.

Back to Networks Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums