To speed up the application

[sabavno]

As I add new features into my application, it starts running slow

Any common suggestions on how to speed up the application?

Thanks

 

[Junior1544]

First, I would suggest compacting and repairing both parts of the app(that is if the db is split)...

Another idea that I use... I have my users use a MDE file... it is fully compiled, and much smaller...

Another idea, don't use domain agregate funtions(sorry for the spelling) such as dmax dcount and the like... those are very slow...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[thargrav]

You also need to review your indexing scheme. And long term, you need to look at archiving your data.

Tom