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