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