[Sqlrelay-discussion] DBI Performance

[David E. <dav...@lb...>]

Thanks, David. Looking forward to 0.37!

On a slightly different topic, I have briefly tried benchmarking the SQL
Relay DBI driver against the standard MySQL DBI driver. Obviously there are
a huge number of variables involved - I am running SQL Relay locally on our
web server connecting to a DB on a different machine, for example - but I
was surprised to find SQL Relay marginally slower. On average, transactions
via SQL relay took 0.16 secs vs 0.13 secs direct. I was hoping for a slight
improvement through connection pooling. Are there any tweaks I could try not
listed on your performance tuning page? Does the socket parameter get used
by the DBI driver? Or would I be best off rewriting my DB wrapper to use the
SQL Relay API directly rather than via DBI?

David

-----Original Message-----
From: David Muse [mailto:dav...@fi...]
Sent: 08 November 2005 04:04
To: sql...@li...
Subject: RE: [Sqlrelay-discussion] Perl compilation error with 0.36.4


Hmmm, I'll have to look into that a bit deeper.  Adding a $ in front
will have the effect of requiring the 3rd argument to be the string
"SQLRelay::SQL_CLOB" to bind a clob.  I'm not sure that's right, but if
you don't use clob's then go with it :)

I'll figure out what's what though and fix it in the 0.37 release.

Dave
dav...@fi...

On Fri, 2005-11-04 at 15:03 +0000, David Edwards wrote:
> Hi David,
> 
> Thanks for replying. I've tried the replacement file, but still got the
same
> compilation error. I did try inserting a $ in front of
> DBD::SQLRelay::SQL_CLOB and DBD::SQLRelay::SQL_BLOB on lines 282 and 294,
> and this did get rid of the compilation error. However, I don't know
whether
> the resulting code does what it's supposed to do, because I'm not using
> CLOBs or BLOBs.
> 
> Regards,
> 
> David 
> 
> -----Original Message-----
> From: Firstworks/4access [mailto:dav...@fi...]
> Sent: 04 November 2005 14:48
> To: sql...@li...
> Subject: Re: [Sqlrelay-discussion] Perl compilation error with 0.36.4
> 
> 
> Hmm, looks like DBD::SQLReay::SQL_CLOB and SQL_BLOB aren't defined.  Try
> replacing /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm with the
> attached file and see if it works.
> 
> David Muse
> dav...@fi...
> 
> On Thu, 2005-11-03 at 10:56 +0000, David Edwards wrote:
> > I am trying to use SQL Relay via the DBI driver from a simple Perl
script,
> > but have run into a problem. On our development environment - using SQL
> > Relay 0.33.1 - we have no problems. However, using SQL Relay 0.36.4 on
our
> > production environment, trying to run the same script results in the
> > following Perl error:
> > 
> > install_driver(SQLRelay) failed: Bareword "DBD::SQLRelay::SQL_CLOB" not
> > allowed while "strict subs" in use at
> > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 282.
> > Bareword "DBD::SQLRelay::SQL_BLOB" not allowed while "strict subs" in
use
> at
> > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 282.
> > Bareword "DBD::SQLRelay::SQL_CLOB" not allowed while "strict subs" in
use
> at
> > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 294.
> > Bareword "DBD::SQLRelay::SQL_BLOB" not allowed while "strict subs" in
use
> at
> > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 294.
> > Compilation failed in require at (eval 4) line 3.
> > 
> > Is this an issue with our Perl, or a problem with the SQL Relay code? If
> the
> > former, does anyone have any suggestions as to how to solve the problem?
> > 
> > Thanks,
> > 
> > David
> > 
> > 
> > 
> > -------------------------------------------------------
> > SF.Net email is sponsored by:
> > Tame your development challenges with Apache's Geronimo App Server.
> Download
> > it for free - -and be entered to win a 42" plasma tv or your very own
> > Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> > _______________________________________________
> > Sqlrelay-discussion mailing list
> > Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> > 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server.
Download
> it for free - -and be entered to win a 42" plasma tv or your very own
> Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 



-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion