Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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?

asked 01 Dec '12, 07:43

Marko's gravatar image

Marko
56449
accept rate: 0%

edited 01 Dec '12, 09:24

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×70
×33
×6

question asked: 01 Dec '12, 07:43

question was seen: 1,884 times

last updated: 01 Dec '12, 09:24