text_combined: barry flanagan qstdstmehgcflanaganie 19 nov 2007 1537 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 man split name split split file pieces synopsis split option input prefix description output fixedsize pieces input prefixaa prefixab default prefix x input input read standard input 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 doubt problem even mssql back topic would mysql running linux faster searching table 70 fields 200000 rows mysql search millions rows problem long decent indexing hope helps barry flanagan fri 08 aug 2008 125722 0000 ilug splitting large csv file