Re: Large 30 GB Database
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 John Smith in London. > All Sarah Dean in St Johns Road, Manchester. > > Should I even attempt this using mysql? > Has anyone played with this much data in mysql? 30GB is not an issue for MySQL. It's not that big. Of course if you do table scans (queries on non-indexed columns) they will be as fast as the disks are (read - slow). But indexed 30GB is absolutely ok for MySQL. You may also consider to bear in mind the SOUNDEX function of MySQL: http://dev.mysql.com/doc/mysql/en/String_functions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Large 30 GB Database
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 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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Large 30 GB Database
>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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Large 30 GB Database
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, Manchester. Should I even attempt this using mysql? Has anyone played with this much data in mysql? Thanks Robert -- Robert Harrison Bsc MBSC CITP IT Manager Harrison Goddard Foote +44 113 2330110 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]