Hi Helen,

Just as I think I understand a topic, I'm been repudiated :)

>I think your statement above means that you run one instance
>of your application for each user that connects to your webserver....does it?

No It's one process with a thread per user. The IntraWeb technology (from AtoZedSoftware) automatically offers thread safety. I may use the pooling component of Arcana Technologies for pooling of connections of all the threads in the process. As I understand it, one use one Database connection per process and all the threads (users) share that connection. The same way I may open one superfluous connection in the process to the database and therefore the process will keep the database open even if there's no activity from users (threads) for a prolonged period of time (say hours). I guess I've again did some "terminology confusion" :)


You also mentioned:

>I don't know. Can they? can't they? This isn't a newsgroup, though. It is a mail list. If you are reading these messages as news articles on >news.atkin.com then you are seeing a news mirror of the mail list archive.

The indexing service of Tamarack Associates is free of charge (as an advertisement for their software I presume). I could not try news.atkin.com, it seems the server is down. But try the search facilities of www.tamaracka.com (either the archives of Borland or Microsoft newsgroups) and notice the speed and functionality. For example, I get 1000+ archived postings in 15 ms if I search for 'helen borrie' in the Borland newsgroup. In the results, I may easily follow each thread.

>You would want to shorten the socket timeout setting on the NOS, so that the Firebird
>server gets notified sooner and can clean up the dead transactions that much sooner.

Sometimes I get the message displayed below (I'm not sure whether it's from FireBird or Apache.) But when I get it, only the one application (Apache dll) freezes but not the other also using FireBird. If it has to do with FireBird, will the more frequent "clean up the dead transactions" alleviate the problem?

Internal Server Error 500
--------------------------
Exception: EWebBrokerException
Message: Maximum number of concurrent connections exceeded. Please try
again later.



Regards,

Nols Smit




Disclaimer Legal Notice:
By having opened and read this electronic mail, you are deemed to have
understood and accepted all disclaimers and conditions pertaining to
electronic mail emanating from, and received by The Council for Geoscience,
further detail of which may be viewed at the following hyperlink:
http://www.geoscience.org.za/disclaimer.htm




[Non-text portions of this message have been removed]