List:Internals« Previous MessageNext Message »
From:saf Date:December 2 2005 12:29pm
Subject:Re: Speed patch for escape_string_for_mysql (libmysys)
View as plain text  
On Fri, Dec 02, 2005 at 10:11:05AM +1000, Arjen Lentz wrote:
> Hi Stephan,
> 
> saf wrote:
> >I'm developper at the NOOFS project (filesystem which saves its data in a 
> >SQL database).
> >I needed more speed for the function escape_string_for_mysql(...), so I 
> >changed the source code.
> 
> Mark Matthews and Konstantin Osipov are looking at it.
> You'll hear back from them.

I forgot to tell you:

Once you have patched MySQL 5 with this patch,
please try to compile the libmysqlclient_r (or libmysqlclient / libmysys)
with gcc with the compiler options:
-O3 -fexpensive-optimizations -funroll-loops

It's possible that without this optimizations, you will not see a big speed
difference.

-- 
Best regards,
Stephan FERRARO
NOOFS Core Developper - http://www.noofs.org/
GnuPG public key: gpg --keyserver www.keyserver.net --recv-key 94B2664F

Attachment: [application/pgp-signature] Digital signature signature.asc
Thread
Speed patch for escape_string_for_mysql (libmysys)(saf)1 Dec
  • Re: Speed patch for escape_string_for_mysql (libmysys)Olaf van der Spek1 Dec
  • Re: Speed patch for escape_string_for_mysql (libmysys)Arjen Lentz2 Dec
    • Re: Speed patch for escape_string_for_mysql (libmysys)(saf)2 Dec