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
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
>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
Hi All,
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 John Smith in London.
All Sarah Dean in St Johns Road, Manc
