OICGI Select statement blocks the Server (OpenInsight 16-Bit Specific)
At 05 APR 2002 09:39:09AM David Schranz wrote:
I am testing OICGI and have come across a mayor issue.
If I have triggered a SELECT statement on the server, OICGI does not allow me to access any other items until the SELECT is complete!
Is there a way to (kind of YIELD()) slow down the process but give time to other uers to access the site.
It seems as though OICGI works on the current command and ignores all others until the command has been fully processed!
Any suggestions!!
TKS
David Schranz
At 05 APR 2002 12:07PM Don Miller - C3 Inc. wrote:
OICGI is single threaded so until it's done with the select nothing else happens. You may want to check Sprezz's S/WEB which is not designed this way.
Don Miller
C3 Inc.
At 05 APR 2002 03:38PM David Schranz wrote:
Is there any way to have multiple OICGI sessions running simultaneously!
Tks
David Schranz
At 05 APR 2002 03:41PM Don Miller - C3 Inc. wrote:
The short answer is NO.
Don
At 05 APR 2002 04:09PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
As Don points out, amongst the reasons we developed S/Web was to get away from this issue of sessions tieing up the server when performing an extended process. We also developed it for a number of other reasons including sheer speed of application development by providing an object oriented web friendly programming environment (as witnessed by our two more recent installations who all had demonstrable products within a day of installing S/Web - developed in house, not by us ), compatibility with all versions of IIS, extensible security to any level, ASP style page behaviour, on the fly R/Basic compilation etc etc. For intranet use we find that the multiple S/Web server approach is almost mandatory especially with heavy usage.
Full documentation is available on line at our web site!
World Leaders in all things RevSoft
