I hit a performance issue on using with intraweb when concurrent say 10 connection to get the data.
db: firbird 2.5
I write testing web client , simulate a flow
- Login ( make connect and get db password and compare)
- go to data list page ( data row is 1x)
- go to another data page ( data row 3x)
if one client it is 4 second, if 10 client it go to 14 second case, if 20 client it go 40 second case,
as contacted to the intraweb, I try to narrow down the case by only write DA client.
The PC client, dynamic sql get data for 2 table（ ensure each client mark request at the same time , it is concurrent) , I compare httpchannel and IndySuperTcpchannel , no much difference
- client 3 second
5 client avg 5 second
10 client avg 10 second
if I need check what is the perfomance bottleneck.
Any advise to find the reason ?