niall broin aljypmagicgoesherecom 19 nov 2007 1537 thomas rooney wrote 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 regularly import files larger mysql though fair mysqldump however id surprised mysql limit size csv file would import ot side issue file exported mssql database 250000 rows normalised data mssql server slowing grinding halt one tell large data set mssql server box runs getting 2gb ram 2 p4 cpus fast disks runs database im going archive 200000 rows mysql server hope take load mssql server back topic would mysql running linux faster searching table 70 fields 200000 rows sorry described piece string question faster exactly searching optimised table indices place analysed queries see bottlenecks questions questions know questions need asking niall fri 08 aug 2008 125655 0000 ilug splitting large csv file