Hi everyone.
I have been having a few problems over the last 6 months with the performance of 6 databases I have created for the web.
They are all stored on a virtual server, the server has been given 2 dedicated processor, and 2 gig ram, plenty of hdd memory too.
The system shows it is running between 2% - 10% so I know it is is not maxed out.
The issues I have been having have escalated over the last 2 months, and now it is becoming a major problem.
The simplest of functions (ie. @command([editdocument])) is taking for ever to do, click the button, and the blue loading bar in IE just loads, and loads and loads…for 5-10mins if left.
When saving (@command) and an agent runs on websave to give it a new number, it is taking for ever to run the agent, saving the document, not letting the agent finish running cos it just hangs.
The slowness is not on 1 database, ranging from edit, to opening a document, to saving, all are starting to take their time.
The smallest, simplest database has about 5 forms, 5 views and around 2,000 documents, and takes its time doing anything.
The largest has around 50 forms, 20views, and about 250,000 documents.
I have been assured the virtual server is good enough to run multiple databases.
Has anyone had any performance issues like this before, and if so how did you combat it?
If not, does anyone have any ideas on how to test/check to see where the problem(s) may lie?
Many Thanks in advance.