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 10mb of file (2 months) where in my single table recordcount was reached 15000 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 take 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
