Re: Using DBI, better option than importing into @array



I'm sure that the
bottleneck is with this array.

How do you know that? Anyway, it seems to me that you can easily skip
that array.

I don't actually know it, but it's my best guess. When the program
used flat text files, it had gotten pretty slow, too, and the only
thing that the 2 scripts have in common is this large array.


for ( 0 .. 20 ) {
my $topiclist = ... id=" . $dbh->quote( $filelist->[$_][0] ) . " ...

Thanks, Gunnar,

Jason

.



Relevant Pages

  • Re: optimizing simple-arrays
    ... I'd expect your get-floatN routines to ... have to perform the array lookup at each reference, ... You might do better, also, to have maxvalue as single floats ... > function was the exact bottleneck, so I just optimized the whole thing ...
    (comp.lang.lisp)
  • Re: Efficiency Question: Large Arrays vs. Indexed Files on Alphas
    ... >decide to read some fields of some records into an array and ... I remember those days with I/O in BASIC was a bottleneck. ... I'd go ahead an use an RMS Indexed file. ... With good bucket sizing and ...
    (comp.os.vms)
  • Re: Anyone can explain this? About iowait.
    ... > bottleneck or problem? ... service time of 5ms, then odds are everything is OK. ... However if your RAID array has a service time of 5 seconds (ie, ... 100% busy may or may not be a problem. ...
    (comp.unix.solaris)
  • Re: Logon script - function array and select case not working
    ... I am trying to rewrite my logon scripts which are all in vbscript. ... set objTSout = objFSO.CreateTextFile ... objTSout.writeline retrv ... below, i am trying to have a dynamic array, becuase this is polling group member ship and everyone will be different. ...
    (microsoft.public.scripting.vbscript)
  • Re: Recordset or Array?
    ... I'd be interested in seeing the scripts. ... that GetRows returns an array of variants. ... Just because the client side recordset loads and stores all the data at once ...
    (microsoft.public.inetserver.asp.db)