stephen brooks wfhginovdtfjplincorcom 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 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 doesnt sound exceptionally large possible issues 1 index key frequent query 2 poor row types size inefficient ie storing numbers strings andor table structure 70 fields sound high 3 poor queries stephen brooks digital depot thomas street senior software engineer dublin 8 ireland lincor solutions ltd ph 353 01 4893683 fri 08 aug 2008 125644 0000 ilug splitting large csv file