Skip Menu |

This queue is for tickets about the Net-MySQL CPAN distribution.

Report information
The Basics
Id: 1332
Status: new
Priority: 0/
Queue: Net-MySQL
People
Owner: Nobody in particular
Requestors: coderx [...] coderx.net
Cc:
AdminCc:
Bug Information
Severity: Normal
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Thu Jul 25 10:59:49 2002 Guest - Ticket created
Subject: Hang on Large Query
Seams that, when i issue a large query( insert ), it hangs and fails to even error, it seriously just "hangs" like its waiting for somthing, I checked the query with the mySQL server, and it worked fine, *shrug*, I fixed the problem, by just breaking the query into 2 or 4, etc.. pieces, I noticed this when issuing an insert, with about 20 values or more. I haven't had time to test it much, to find out if its the number of Values that makes it hang, or the actual size of the data going into the query. Sorry im not more help in finding/fixing the bug, but I hope this helps. Thanks, --Jason C.
  Fri Jul 26 04:38:37 2002 oyama [...] module.jp - Correspondence added
Subject: Re: Hang on Large Query
From: oyama [...] crayfish.co.jp
Hi, In the protocol of MySQL, since SQL is treated as one string, the number of VALUES of SQL is unrelated. However, when SQL of 256 or more characters was used, the hang-up problem was in *old* Net::MySQL. Please tell me the version of Net::MySQL and Perl. And if Net::MySQL is older than version0.04, this problem is already solved. If it is not an old version, Please tell the following information. 1. Version of your Perl. 2. Version of your Net::MySQL. 3. Actual SQL which a problem generates. It is glad when there is also a debug message of the scene where a problem arises. ex) my $mysql = Net::MySQL->new( #... debug => 1, ); Thanks. Show quoted text
______________ Hiroyuki OYAMA