Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

Database connections...........

 [1/2] from: john:dutcher:highmark at: 17-Nov-2009 8:31


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.

 [2/2] 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.