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: 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: 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: 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)
  • RE: Need help with a regex
    ... I just did a quick test on my real file and it ... I definitely still have a lot to learn with both Perl and regex's, ... Such as how you initialized the array. ... Those scripts produced the output I wanted, ...
    (perl.beginners)