As he said No Worry Be Happy<G> A small table I just did was 78meg 90,000+ rows, 26
fields and imported it from a DBF file and had it running in no time..Love MySQL!!!
-----Original Message-----
FROM: Kenneth Kopelson
TO: Johnny Withers, Mike Mike, [EMAIL PROTECTED]
DATE: Wed 6/6/01 12:51
SUBJECT: RE: Inserting 307,284 lines. Is this ok?
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
---------------------------------------------------------------------
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
