Harish TM a écrit : > hi... > I need to store something like a couple of million rows is a MySql > table. Is that ok or do I have to split them up. I intend to index each of > the columns that I will need to access so as to speed up access. Insertion > will be done only when there is very little or no load on the server and > time for this is not really a factor. I also do not have any constraints on > disk space. Please let me know if I can just use MySql as it is or > if I > need to make some changes > > harish >
Many peoples have multi-millions tables and it's all fine. The only thing is that MySQL built table with a default of 4Gb maximum. It's possible to go but you need to consider it if you think your table may grow bigger than that (for MyISAM that is)! -- Mathieu Bruneau aka ROunofF === GPG keys available @ http://rounoff.darktech.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
