Hello there,
Wondering if anyone could help with a problem. I'm upgrading a customer's server from a text based version of our program, to a MySQL based. There are 2 databases, DB1 and DB2, which contain 5 and 4 tables respectively. The upgrade script I am running simply adds information to 3 of these tables. First, a table in DB1 which contains 23 columns, each entry having from 2 to 100 characters. Then, the other two tables, one in DB1 and one in DB2, which each contain 5 columns. First column contains a number with a maximum of 5 digits, and the other four columns contain 1 digit each. Now, the upgrade script simply grabs information from many different text files and inserts it into the 3 MySQL tables. However, for some unknown reason, MySQL seems to stall or time out just after 43,530 entries. I have upgraded probably over 30 web servers now, and there has never been a problem except for this one. This one is the largest database I have upgraded yet though. Any ideas??? Would an upgrade to Oracle help at all? Is this pushing the limits of MySQL? Thank you, Matt Wagner Envex Developments Your CGI Script Specialists http://www.envex.net/ Phone: (780) 707-2657 --------------------------------------------------------------------- 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
