Re: DBD::mysql mysql_server_prepare=1 anyone?

2006-10-08 Thread Gustavo Delfino
I have compiled a fresh copy of perl 5.8.8 (which defaults to no threads) and I still get the same Bus error. So maybe this is not related to threads. So, if this is not related to threads, recompiling mysql with -with- thread-safe-client will probably not help. My next experiment will be

Re: DBD::mysql mysql_server_prepare=1 anyone?

2006-10-08 Thread Dominic Dunlop
On 2006–10–08, at 13:41, Gustavo Delfino wrote: I have compiled a fresh copy of perl 5.8.8 (which defaults to no threads) and I still get the same Bus error. So maybe this is not related to threads. Thanks for putting in the effort to try. Too bad it had no effect. You should add a

Re: DBD::mysql mysql_server_prepare=1 anyone?

2006-10-07 Thread Dominic Dunlop
On 2006–10–06, at 21:58, Gustavo Delfino wrote: Any advice on how to solve this? Well, I can't help you, but I know someone who can. Or who should be able to, anyway. Go to http://search.cpan.org/~capttofu/DBD- mysql-3.0007/ and repost your question through the View/Report bugs link

Re: DBD::mysql mysql_server_prepare=1 anyone?

2006-10-07 Thread Gustavo Delfino
However, the DBD::MySQL man page says The obvious question is: Are the C libraries thread safe? In the case of MySQL the answer is mostly and, in theory, you should be able to get a yes, if the C library is compiled for being thread safe (By default it isn't.) by passing the option

Re: DBD::mysql mysql_server_prepare=1 anyone?

2006-10-07 Thread Sherm Pendley
On Oct 7, 2006, at 2:26 PM, Gustavo Delfino wrote: I now want to try with the -with-thread-safe-client option, but I don't know how to add it. It's not a Makefile.PL option. It's a configure option when you're building MySQL itself. sherm-- Web Hosting by West Virginians, for West

DBD::mysql mysql_server_prepare=1 anyone?

2006-10-06 Thread Gustavo Delfino
Hello, I am trying to make my DBI application faster. According to DBD::mysql documentation I should be able to prepare a query that I'm going to use in a loop so that when I execute it inside the loop, it goes faster. In order to maximize this performance improvement, you need to add