On 2003-03-03 13:35:36 +0100, Peter Schuberth wrote: > I have changed from > MySQL DB to CSV File (DBD::CSV). > And also from Linux to Windows
Neither seems like a smart move to me.
Changing two things at once definitely isn't.
> 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?
or of DBD::CSV? Depending on the size of the tables and the complexity
of the query DBD::CSV can be a lot slower that MySQL.
> B)
> I have a select like this:
> ...WHERE ((field1 like ?) OR (field2 like ?) OR (field3 like ?)) AND
> ((field1 like ?) OR (field2 like ?) OR (field3 like ?)) AND
> ((field1 like ?) OR (field2 like ?) OR (field3 like ?))
>
> values1,values1,values1,values2,values2,values2,values3,values3,values3
>
> with Linux this is not a problem, but under Windows I get no data and also no error.
>
> I removed the "field3" only then I got data with Windows, but the
> result looks like WHERE ((field1 like ?) OR (field2 like ?)) has been
> used for the search.
Have you tried the same query with DBD::CSV on Linux? Or with DBD::MySQL
on Windows?
> C)
> There is a different in the order of a table when I use it under Linux
> or Windows. Under Windows the order is fine but under Linux it looks
> mixed up.
If you want the result of a select to be ordered you have to use an
"ORDERED BY" clause. Tables have NO defined order in SQL.
hp
--
_ | Peter J. Holzer | Unser Universum w�re betr�blich
|_|_) | Sysadmin WSR / LUGA | unbedeutend, h�tte es nicht jeder
| | | [EMAIL PROTECTED] | Generation neue Probleme bereit.
__/ | http://www.hjp.at/ | -- Seneca, naturales quaestiones
pgp00000.pgp
Description: PGP signature
