On Wed, Feb 16, 2005 at 09:44:08AM -0800, Jeff Zucker wrote :
> [EMAIL PROTECTED] wrote:
>
> >Total Elapsed Time = 63.19465 Seconds
> > User+System Time = 43.46465 Seconds
> >Exclusive Times
> >%Time ExclSec CumulS #Calls sec/call Csec/c Name
> >66.5 28.91 36.463 109445 0.0003 0.0003 SQL::Statement::eval_where
> >
> >
> I'm the maintainer of DBD::CSV and while I don't have time this week to
> get into this, I am following the conversation and will certainly
> eventually revise the module if any useful information is discovered.
Sorry for wasting your time with my problems, but since I
changed the i386 computer, I can not reproduce the speed difference
anymore. And I do not have access anymore to this computer where the
query was running faster to double-check wether everything is exactly
the same than on the new one.
As I had better to spend my time on analysing some data with
my script rather than analysing the script itself, I eventually
swiched to DBI::SQLite, which solved my problem by performing the
query in a few seconds.
The query was something like :
$query = "SELECT * FROM $db_table WHERE SYMBOL1 LIKE \'%${Search}%\' OR
SYMBOL2 LIKE \'%${Search}%\'" ;
my $sth = $dbh->prepare($query);
$sth->execute;
(actually CLIKE, before the transition)
You may wonder the purpose of this mail, as there is no new
crucial information. The reason is that I do not like not knowing the
end of the story when I browse archived threads.
Anyway, many thanks to all that tried to help me.
--
Charles