Re: Large 30 GB Database

2004-07-29 Thread Egor Egorov
Robert Harrison <[EMAIL PROTECTED]> wrote: > I have been asked to provide a searchable electoral roll. > > This data comprises of first name, surname, address for every person > over 18 in the UK. Approximately 30 GB > > The data is to be used to find people in a certain area. > > EG > All Joh

Re: Large 30 GB Database

2004-07-28 Thread Rich Allen
i have one MySQL dB that is currently about 26Gb, properly indexed searches are very quick - hcir On Jul 28, 2004, at 4:23 AM, matt ryan wrote: >Should I even attempt this using mysql? >Has anyone played with this much data in mysql? I've got two 100 gig databases in mysql, and slave replication

Re: Large 30 GB Database

2004-07-28 Thread matt ryan
>Should I even attempt this using mysql? >Has anyone played with this much data in mysql? I've got two 100 gig databases in mysql, and slave replication on both of them, the only time I have a problem is table scans, that much data will be slow. -- MySQL General Mailing List For list archives: h