proinnsias breathnach vfnkdycxsylinuxie mon nov 19 2007 033753pm 0000 thomas rooney wrote hi one help csv file data base 180mb size want split several smaller sized files say 24mb importing mysql im issues importing may size 24mb seems work fine wc l head tail friends use mssqls bcp options split output multiple files based number rows ot side issue file exported mssql database 250000 rows normalised data mssql server slowing grinding halt one tell large data set mssql server thats even large dataset msaccess large mssql dataset would order billions rows per table hundreds constituent columns one current production database work sybase 400 tables sample table 120 cols 150 million rows box runs getting 2gb ram 2 p4 cpus fast disks runs database im going archive 200000 rows mysql server hope take load mssql server problem likely neither hardware database size rather data structure database indexing strategy look query plans generated general queries youre running theyll typically point problems know youre looking back topic would mysql running linux faster searching table 70 fields 200000 rows probably said data isnt problem instance structure p fri 08 aug 2008 125639 0000 ilug splitting large csv file