On 05-Jun-01 Mike Mike wrote:
> Hello
> I was wondering if inserting 307,284 is to much to put
> into one table. Can MySQL handle this?
No. Easily.
I have several tables > 1,000,000 rows, the largest
at 1.7G; many folks have more.
> 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.
Does the OS see & use the 256M ? if no, then MySQL can't use it.
> 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.
First, normalize the dataset, then design tables to fit the
function, and finally analyze your queries for indexing.
The size is not (normally) an issue in table design; either
you have the disk space or not.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
---------------------------------------------------------------------
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
