Greetings. I would thank some feedback on this issue. The doubt is: Should i create a table, with about 40-65 fields (ID, 3 or 4 of text, the reamining of small/tiny int), or should i split it in about 4-6 tables, dividing the fields between them? Info: The database would be read/write by PHP, and it would have around 1500-2500 users (distributed by the day), with about 150 queries each user. In each query, around 10-20 fields values would be needed. The queries would mainly be SELECT and UPDATE...
I did read the optimisation part in the manual, particularly: "It's not normally useful to split a table into different tables just because the rows gets 'big'." >From http://www.mysql.com/doc/T/i/Tips.html , "Other Optimisation Tips". http://www.mysql.com/doc/C/r/Creating_many_tables.html, "Drawbacks to Creating Large Numbers of Tables in the Same Database" but still didnt got an straight answer for my precise case. Unfortunally i'm new at this (both MySQL and PHP), so i apolozige for any mistake/stupidity presented in the question... :) I will, in lack of contrary info, use 1 table with many fields... Thank you for any comments. Gath --------------------------------------------------------------------- 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
