On Tue, Jul 7th, 2009 at 1:43 PM, fos...@tpg.com.au wrote:
>
> I have a strange thing happening with mysql on a basic ubuntu
> system.
>
> It appears that perl DBI does not always get a response, I can
> issue
> the the same command in mysql command line and it returns quickly but
> in
> DBI it appears to be slow.
>
> I am returning a pretty large chunk of data 249,190 rows but only a
> numeric ID.
>
> Any suggestions?
After trying multiple times I stumbled across
$selectPlayers->{"mysql_use_result"} = 1;
I have to use multiple connections to the DBI but it all works
reasonably quickly now.
Thanks
Ken
_______________________________________________
coders mailing list
coders@slug.org.au
http://lists.slug.org.au/listinfo/coders
