Peter Schuberth wrote:

On the same hardware system
the same select for the same table

Please check your version of SQL::Statement which is the module that determines the speed and capabilities of DBD::CSV. Put these two lines at the top of the scripts:

   use SQL::Statement;
   print $SQL::Statement::VERSION;

It sounds to me like you may have the XS version of the module on one install and the pure perl version on the other. You can read about the difference between the two at

http://www.vpservices.com/jeff/programs/sql-compare.html

If you have a moderately large data set and speed is an issue, then the XS version will be better but MySQl, PostgreSQL, or SQLlite will be even faster. DBD::CSV is really meant for relatively small data sets and relatively uncomplicated querries.

Another issue: if you are trying to access the same data file from both windows and linux, you'll need to specifically set the csv_eol for the table. It doesn't really matter which you choose, either "\015\012" or "\012". If the script sets it to either one of those and the data matches, then the same file can be accessed from both windows and linux without changing the file or the script. That sort of multi-platform accessibility can be achieved with the other DBDs, but probably not as simply.

You may be running into some bugs I am working on relatvie to parentheses in WHERE clauses. I'd appreciate it if you could send me any sample queries that don't work for you.

--
Jeff



Reply via email to