Sorry if this is a re-hash of old topics but I haven't been able to figure this out from the docs or in the forums.
I'm starting a new project which requires a web app whose sole purpose is to provide webservices for desktop client apps. I've got the following questions:
1) Since each "service function" is going to be routed thru the HandleSpecialURL event:
A) Does the web app automatically spawn a new thread each time this event is raised?
B) If no automatic thread is raised, can I create my own threads from within this event where the real work will be done?
C) OR can I create Session objects instead of threads to do the work?
- I'm going to use PostgreSQL as the DB - does anyone see a problem with having the App open and maintain the DB connection and pass a reference to this connection to the session or thread that does the work?
- Potentially there can be hundreds/thousands of simultaneous requests against this webservice - are there any scalability issues I should be aware of?
- I'm thinking this needs to be deployed as CGI - thoughts?
Sorry for what may seem like beginner questions. I've done plenty of apps like this with .NET, VB and IIS but this is a first for me with Xojo.