Hello let me understand so I can experiment.
is sql.so loaded when I do package require sql. or is it a static module for the apache? is the ::sqlhand is what you reffer to as the connection (sql query ::sqlhand "SQL SENTENCE")? can it stands a heavy duty work? Yahalom Emet Software Developer Xor Technologies Ltd. ----- Original Message ----- From: "Wojciech Kocjan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, October 29, 2001 1:48 PM Subject: Re: package sql > I keep my SQL connections open all the time - this is the faster way > (that is, ab gives you more req/sec ;). > > Try this solution: > - loading sql.so at GlobalInit > - putting 'set ::sqlhand [sql connect ...]' somewhere in ChildInit > - putting 'sql disconnect' in ChildExit > > But then you have to watch for sql endquery - this is a PITA, at least > for me :> > > Try http://dtcl.zoro2.org/ and my own 00sql.tcl - I use my own wrapper > functions for mySQL - mostly because it's easier to > foreach entry [sql::q_list "SELECT * FROM table"] than to > connect,query,fetchrow,endquery,disconnect :) > > -- > WK --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
