Urgent : Nubuilder Slowing Drastically

[at_rcc]

Dear Friend,
I am having a recent problem with nuBuilder it has suddenly because drastically slow. I have about 3000-4000 customer records with some 4000 invoice and each invoice consist of atleast 5 items. The system is run locally on a LAN server dedicated to its purpose, even by shifting the system on a more powerful work station ,the results yield the same. Need help to know how to make the system work normally again . It is taking around 2 minutes to load a customer record properly and 3 mins to load its invoice and so on.

[admin]

at_rcc,

Essentially the speed of nuBuilder comes from the speed of mysql.

The main way to a make a mysql table fast is to have indexes on the fields searched or used to look up a record.
4000 records is hardly any, we have tables with hundreds of thousands.

Does your customer and product table have Primary and Foreign Key indexes?

They need to.

Steven

[at_rcc]

Dear Steven,
Here is a sample dummy of the database relationship as i have build in mysql and perhaps it may help you understand the system i am trying to use.

[at_rcc]

Dear Steven,
yes my customer table does have an index and so does my product table, your software was working fine until recently don't know what happened that it slowed down. I am including screen shot of the customer screen and invoice screen