When working with classic desktop client applications database connections persist during the whole login session, whereas in the 'web world' I can't find any similar approach to reduce overhead:
- db connects per every request, on Win IIS + PHP cgi sasql_connect can take up to 0.15s
- filling working (global)temporary tables on every request, when data should persist over HTTP requests
I'm aware of sasql_pconnect, which I'm afraid works only on Unix/apache system but fails on Win/IIS.
What are the recommendations for solving such performance issues?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.