Hello Jenda, I have used the same data under Linux and Windows, also the same scripts. The times I gave in A) are only for the select of the CSV table not for the script. But comparing the select query with the execution of the rest of the script, select is taking most of the time. Under Windows (Script total 2.5 sec. Search 2.0 sec).
I have also changed now to Apache 2.00.44, then the query is 0.15 seconds faster under Win. Peter ----- Original Message ----- From: "Jenda Krynicky" <[EMAIL PROTECTED]> To: "Peter Schuberth" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, March 03, 2003 4:22 PM Subject: RE: DBD::CSV > From: "Dan Muey" <[EMAIL PROTECTED]> > > > A) > > > But now I discovered few problems: > > > On the same hardware system > > > the same select for the same table > > > > > > 1) Linux the select takes 0.4 seconds > > > > > > 2) Windows the select takes 2.1 seconds > > > > > > Using Apache 1.3.27 and under Windows ActivePerl. > > > > > > Is it a problem of Apache, Perl or the OS? > > > > THE OS !!!!!! WINDOWS is an expensive resource cow, designed to stop > > working every 2.5 years And make you think you can't live with out it. > > Please stop flaming based on your personal tastes. It is true that > Windows use more resources than Linux in the default setup, but the > difference Dan sees has nothing to do with this. > > It's caused by the DBD::CSV. If he installed Mysql and kept using > DBD::mysql he'd see roughly the same results. > > Dan, you may want to take a look at DBD::SQLite if you do not want to > install mysql. > > Jenda > P.S.: Dan, could you try to run the script using DBD::CSV, using the > same data, under Linux and let us know how long did it take? > ===== [EMAIL PROTECTED] === http://Jenda.Krynicky.cz ===== > When it comes to wine, women and song, wizards are allowed > to get drunk and croon as much as they like. > -- Terry Pratchett in Sourcery > >
