BorlandTalk.com

Chopin · Guest

Hi,

I have a 3 tier app:

1) ISAPI DLL using Client DataSets
2) App Server using the providers for 1) and also using ADO to connect to
database (mysqlODBC 3.52)
3) mysql database (latest from 3.x)

1) and 2) is written in Delphi 5 enterprise (latest update packs) and using
MIDAS + scktsrvr (the latest version).

The ISAPI DLL is using SocketConnection and each WebRequest is
a) SocketConnection.Active := true;
b) Doing SQL commands using CliendDataSets (SQL.Execute) or using table
access ClientDataSet (xxx.Open)
c) If open ClientDataSet is closed
d) SocketConnection.Active := false;

The App Server has no code it directly uses providers for ClientDatasets
using ADOConnection to the database.

The situation is that using this with good machines (P4 3.2GH, 1gig memort
fast HDD) for each tier, the maximum speed is 50 concurrent users, even then
the wait time is 30-50 seconds, and if there are more than 50 users it times
out.

How can we optimize it? What suggesstions do you have to check if I can make
it better? If you have suggestions for optimizing IIS settings, mysql
configuration, I'd be happy to hear from those too.

Also how using D7 with the same structure will perform better?

Thanks,

Chopin