Networks

Ask something
Discussion Locked

Enhance performance

0 helpful
2 replies

by ila97

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Currently 1 have 20 years data in my database which had cause my application to run very slow. How do I go about it?

2 replies

by mozster

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.

by ila97

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

This discussion is closed to new replies.