RE: fetchrow_array performance

2004-12-01 Thread Schoenwaelder Oliver
#x27;ll get. Thx so far, Olly > -Original Message- > From: Gaul, Ken [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 01, 2004 2:08 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: fetchrow_array performance > > > Are you sure the query only takes a

RE: fetchrow_array performance

2004-12-01 Thread Gaul, Ken
628140 E: [EMAIL PROTECTED] -Original Message- From: Reidy, Ron [mailto:[EMAIL PROTECTED] Sent: 01 December 2004 12:52 To: Hardy Merrill; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: fetchrow_array performance I agree - set RasieError. But even more, it is impossible to tell what

RE: fetchrow_array performance

2004-12-01 Thread Reidy, Ron
ember 01, 2004 5:24 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: fetchrow_array performance Sorry for the top post - old version of Groupwise at work :-( You aren't error checking your dbi statements - do you have RaiseError set to "on" (1)? If you don't, check each

Re: fetchrow_array performance

2004-12-01 Thread Hardy Merrill
Sorry for the top post - old version of Groupwise at work :-( You aren't error checking your dbi statements - do you have RaiseError set to "on" (1)? If you don't, check each dbi statement like this: my $Statement = $Database->prepare($SQL) or die("Prepare died: $DBI::errst

fetchrow_array performance

2004-12-01 Thread Schoenwaelder Oliver
Hi, I've got a problem with a simple fetch which just takes hours (literaly) to complete. It's a simple select statement which, in the current case, returns about 300 rows within seconds. But the loop is finished a couple of hours later then the last result is printed. Here's a code snippet: