General discussion


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.

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.

Related Discussions

Related Forums