Re: [Sqlrelay-discussion] Sybase/Perl performance - Email found in subject
Brought to you by:
mused
Menu
▾
▴
Re: [Sqlrelay-discussion] Sybase/Perl performance - Email found in subject
|
From: Carlos V. <cve...@em...> - 2010-02-09 19:08:04
|
I separated connection time from query run time. The ping was included in connection time but was negligible so I wasn't concerned with the connection process. I did run some tests without the ping in place just for apples to apples comparison. Again connection time was fast enough to not be a concern. I was more concerned with the query time as those were growing by an order of magnitude with every 1000 rows selected. The patch has successfully fixed this issue. Thanks, CJ Vergara From: David Muse [mailto:dav...@fi...] Sent: Tuesday, February 09, 2010 12:42 PM To: sql...@li... Subject: [SPAM] - Re: [Sqlrelay-discussion] Sybase/Perl performance - Email found in subject Very interesting. I'll run some tests, but I think this is a good patch. The only other thing... I saw in your initial test script that you were doing a ping right after connecting. Does your ctlib test do that as well? That ping will add additional overhead. David Muse dm...@4a...<mailto:dm...@4a...> On 02/05/2010 09:50 AM, Claudio Freire wrote: On Fri, Feb 5, 2010 at 11:48 AM, Carlos Vergara <cve...@em...<mailto:cve...@em...>> wrote: Thank you very much. I will apply it and let you know how everything turns out. I forgot to mention, this patch should be applied on the server side too. (ie: so that the sqlrelay process uses the patched rudiments) ------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting http://www.doteasy.com _______________________________________________ Sqlrelay-discussion mailing list Sql...@li...<mailto:Sql...@li...> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting http://www.doteasy.com _______________________________________________________ Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting http://www.doteasy.com |
