how to do when the table files become bigger and bigger
Hi, all: I am doing a project that we will insert a lot of data to mysql by C API everyday, so the table files will become bigger and bigger, it will not only takea long time to query,but also lead to the file size limits. In order to query fast and avoid leading to the file size limits, I have several ways to resolve it: 1) create all the tables in that database every month. 2) create a new database every month. 3) other ways that I don't know. Would you please give some advise on which one should I choose? Are there some artiles related? Thanks for any help. B.R. budingc - 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
RE: how to do when the table files become bigger and bigger
What is the problem you wish to resolve? Define it. -Original Message- From: Buding Chen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 6:33 AM To: [EMAIL PROTECTED] Subject: how to do when the table files become bigger and bigger Hi, all: I am doing a project that we will insert a lot of data to mysql every day, so the table files will become bigger and bigger, it will not only take a long time to query,but also lead to the file size limits. So how to resolve it? Are there some artiles related? Thanks for any help. B.R. budingc - 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 - 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
how to do when the table files become bigger and bigger
Hi, all: I am doing a project that we will insert a lot of data to mysql every day, so the table files will become bigger and bigger, it will not only take a long time to query,but also lead to the file size limits. So how to resolve it? Are there some artiles related? Thanks for any help. B.R. budingc - 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