[REBOL] Re: Database connections...........
From: pwawood:gm:ail at: 18-Nov-2009 22:43
John
Rebol CGI scripts are reloaded each time a new request is made. In fact, not only are
the CGI scripts loaded for each request, Rebol is as well. This is how I understand all
CGI applications work. In practice it isn't as bad as it sounds Rebol loads very quickly
and typical Rebol CGI scripts perform well. Rebol.org works this way. You probably only
need to worry if you expect to experience high levels of activity on your site.
There is another protocol called FastCGI which doesn't reload a script each time a request
is made. I haven't personally used FastCGI though I know of rebol-based high-volume sites
which do use it.
I don't believe that Rebol/Command supports connection pooling directly. Doc Kimbel's
MySQL and PostgeSQL schemes don't support connection pooling directly. You would need
to build an "application server" that communicated with the web server to implement connection
pooling. This how I understand that Java based systems work. The web server handles the
browser interface and passes the request to a program running on an application server
(e.g. JBoss, WebSphere, Tomcat). These application servers provide the connection pooling
support.
I'm pretty sure that you can get connection pooling and persistent applications in Rebol
(and much more) that you are looking for with DocKimbel's Cheyenne web server ( http://cheyenne-server.org/
). Site Assistant (http://site-assistant.com/) is an example of a site running under
Cheyenne.
The downside is that you'll only be able to use Cheyenne if you control your own server.
I hope this is of some help.
Peter Wood
On 17 Nov 2009, at 21:31, Dutcher, John F wrote:
> Can anyone who "knows" these things comment on whether or not using Rebol Command (or
not using it for that matter) allows for the concept of database connection
> "pooling" (i.e. as in Java) and whether or not Rebol CGI scripts are reloaded each
time a new request for the application is made....or
> loaded once the "first" time an application is requested (maybe more of a server issue
I suppose) ?
>
> ________________________________
> This e-mail and any attachments to it are confidential and are intended solely for
use of the individual or entity to whom they are addressed. If you have received this
e-mail in error, please notify the sender immediately and then delete it. If you are
not the intended recipient, you must not keep, use, disclose, copy or distribute this
e-mail without the author's prior permission. The views expressed in this e-mail message
do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates.
