> Hi all > > What is the maximum records can hold in a single table in mysql. > > I am doing a file upload from text file to a table. > > The records are seperated using year,month,date. I have 2 years of data to > be uploaded. > After I did 2 months where in my single table recordcount was reached > 128500 records, It slow down the process > of Insert/Update/Delete queries. To upload the entire month, normally > (when the database is empty) it takes approx 1 hour. > After 3 months of file upload, now the process time for the entire month > takes 4 hours and its growing as well. > > > How do i increase the performance. > > Anybody can give me the best possible idea to increase the performance. > > My application is running on VB. > > Thanx for all your help > Regards > Prabu
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
