Re: [Sqlrelay-discussion] Sybase/Perl performance

[David M. <dav...@fi...>]

This fix will mainly improve performance on the client side, but the 
server side uses the same class for managing bind variables, so it could 
improve performance on the server side for any database backend.  I 
think you'd see more of a performance improvement on the client side, 
but if you use a lot of bind variables then you would see an improvement 
on the server side too.

Dave
dav...@fi...

On 02/06/2010 05:19 AM, Benoit Cattié wrote:
> Hi,
>
> is this affecting also other database backend ?
> I'm using oracle and i'm wondering if I had to recompile rudiments.
>
> Best regards
>
> Benoit
>
>
> Claudio Freire a écrit :
>    
>> Ok, it turned out that only a very small patch to rudiments is enough.
>> I'll try to push it into rudiments, but in the meanwhile, just apply
>> this patch to your rudiments installation:
>>
>> diff -wur rudiments-0.32.orig/src/memorypool.C
>> rudiments-0.32/src/memorypool.C
>> --- rudiments-0.32.orig/src/memorypool.C    2006-08-05
>> 01:34:47.000000000 -0300
>> +++ rudiments-0.32/src/memorypool.C    2009-08-31 18:54:28.000000000 -0300
>> @@ -88,8 +88,11 @@
>>       // if we didn't find a node with enough memory remaining,
>>       // create a new one at the end of the list
>>       if (!node) {
>> -        memnode=new memorypoolnode((length>pvt->_increment)?
>> -                        length:pvt->_increment);
>> +        size_t incr = pvt->_increment;
>> +        size_t tot = pvt->_totalusedsize;
>> +        if (incr<  (tot/10))
>> +            incr = (tot/10);
>> +        memnode=new memorypoolnode((length>incr)?length:incr);
>>           pvt->_nodelist.append(memnode);
>>       }
>>
>> ------------------------------------------------------------------------
>>
>> ------------------------------------------------------------------------------
>> 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
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Sqlrelay-discussion mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>>
>>      
>
> ------------------------------------------------------------------------------
> 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
> _______________________________________________
> Sqlrelay-discussion mailing list
> 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