If I'm not mistaken, MySQL can handle millions or even billions of rows,
and there is no real limit to the number that reside in a single table. So
Mike Mike relax, you are using a serious database here, not a little toy :)
-Ken
At 01:20 PM 6/5/01 -0500, Johnny Withers wrote:
>At boot time you can pass a flag to lilo to force
>a certian amount of ram..
>i think it's something like this:
>
>lilo: linux mem=256
>
>307,000 rows in mysql is easy, mysql can handle
>a lot more rows than that.
>
>You shouldn't have any trouble with this amount of data.
>
>---------------------
>Johnny Withers
>[EMAIL PROTECTED]
>p. 601.853.0211
>c. 601.209.4985
>
>
>-----Original Message-----
>From: Mike Mike [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, June 05, 2001 11:38 AM
>To: [EMAIL PROTECTED]
>Subject: Inserting 307,284 lines. Is this ok?
>
>
>Hello
>I was wondering if inserting 307,284 is to much to put
>into one table. Can MySQL handle this? Its a 70MEG
>File. I have a 550 with 256MEG ram but it only shows
>64. I don't know how to make it show 256 and running
>redhat 6.1. The table has 12 colums and does not have
>much data in each record. My question is should I
>break this up into a couple of tables so that each
>table will have say 50,000 records and I can just
>search through them with dates.
>Thanks for any help.
> --Mike
>
>__________________________________________________
>Do You Yahoo!?
>Get personalized email addresses from Yahoo! Mail - only $35
>a year! http://personal.mail.yahoo.com/
>
>---------------------------------------------------------------------
>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
>
>
>
>---------------------------------------------------------------------
>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
---------------------------------------------------------------------
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