Re: Persistent connections to database?

["Chris Travers" <..hidden..>]

I understand your issue and by 1.4, I expect that we will have better
options for dealing with it.

Obviously even "persistant" database connections are not very
persistent when they are created in an external process which is
fairly short-lived (as it is when you use the command line or connect
via CGI).  LSMB 1.2.x should be better at this than than earlier
versions (because we don't open/close as many database connection
handles).

However, long-run ,we are working on two things which will make this easier.
1)  Making the software ready for mod_perl or fast_cgi (note though
that this will not address your specific issue alone because of the
fact that each *user* gets his/her own database connection)
2)  Making the core logic for posting invoices/orders available via db
stored procedures.  IN this case, you could use PHP's persistent
connections to place the orders and simply call the stored procedures.
 You could even add connection pooling solutions on your side.  This
is the most important aspect of the scalability tuning.

Best Wishes,
Chris Travers