In my case, I have a client-server architecture. Client collects data and server saves them into embedded firebird database. Clients collect data automaticly and report to server periodically. The number of clients are different in different deployment, from 1 to 500. When there are a lot of clients reporting to server (say, 500), the server load is high. Could you suggest what I shall do?
Best, Sean "Jiri Cincura" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Sean wrote: >> Question: >> In scenario 1, the average execution time for an iteration dropped from >> 1.2s >> to 4s when 2 threads competed for 1 connection from the pool. Is this a >> performance problem? > > Theoretically yes, in real world IMO not so. The pool has great impact > on speed when line or server are busy, under load, etc. Doing this > "batch" opening doesn't make in real app sense - if it's interactive > aplication user is not able do to actions so fast and if it's batch app. > there's no need to use connection pool. > > Just my $0.02. But feel free to fetch sources and do any optimalization > on pool. > > -- > Jiri {x2} Cincura > http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Firebird-net-provider mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
