I've had much the same problems recently.
We have a 12,000 record database running under FM4.1 on a PIII 600. Our internal users access it through a web front end, even though they weren't being properly displayed.
Last weekend I did 3 hours worth of investigation about why it's so slow.
A user does a search which results in 150 records. This search takes the FM4.1 server around 2 seconds.
To transfer this list from the server to the web interface takes an additional 16 seconds!
I thought maybe it was the HTML construction of the display of the records which was taking the extra time, so I removed everything between:
[fmp-record]
and
[/fmp-record]
and it still took 14+ seconds to transfer the 150 records to the web front-end.
So...my question is...how does I speed this transfer up? I could use a faster machine for the server, but it won't get much much faster.
Any suggestions?
Thanks
-Andrew
[ September 01, 2001: Message edited by: AndrewB ]