Hey guys...
Thanks a lot...
Guess I will stick with MySql then
harish
On 5/30/06, peter lovatt <[EMAIL PROTECTED]> wrote:
Hi
We have tables of 1.5M rows 25 fields, in heavy use with frequent inserts
and updates on a P4 with 1GB of RAM. Performance is fine, and the table size
is 400MB, so you should not have any problems.
Peter
On 29/05/06, Chris W <[EMAIL PROTECTED]> wrote:
> 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]
