Optimize performance

[rudymadsen]

I have a relative small database, which suddenly seems to performe very slowly. When I make an edit in the biggest form, it takes over 30 seconds to save the changes.

How can I se, what is wrong - and what do I do to make it right?

/Rudy

 

[___]

Try a Compact and Repair.

Tools >>> Database utilities >>> Compact and Repair Database.

HTH

 

[Mile-O]

There are loads of things you can do to optimise your database's performance. Here's a few.

• Always use queries bound to forms rather than tables. This stops you from loading unnecessary records into a form which - as the records grow - causes it to run slower;
• Only select the relevant fields into a query and not all.
• Try to avoid concatenation;
• Use constants over variables where possible;
• Reduce the number of controls on your forms. Depending on the control these can cause considerable processing time to display;
• Don't allow controls to overlap as each time one comes to the top it takes time to display it;
• Reduce field sizes in strings to plausible lengths. i.e. don't leave a surname field at 50 characters in length as this is not necessary

 

[rudymadsen]

Thanks for the reply..

However, the performance error came suddenly and I don't understand how this could happend.

I will try to make all my relations in the particular forms.

The database is going to work in a multiuser environment and I have split up my database in a frontend and a backend. Is the something that could go whong when I do that?

/Rudy

 

[___]

How does it perform as a single database (not split) on a single pc? It could be the network slowing it down.

 

[rudymadsen]

In this moment it is spilt on the same drive and the same directory...

 

[___]

Try creating a new blank db and import all your queries, forms etc into it......see how the new db runs.