Harish TM wrote:
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
I have a table with around 900,000 rows and I know others have tables
with many millions of rows, I think I read some even have tables with
billions or rows. The limitation you hit is generally because of your
OS. Most OSs have an upper limit on file size. Since a table is stored
in a file, that file size limitation of the OS is what generally limits
the table size. In which case the number of rows depends on the size of
the rows.
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http://thewishzone.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
