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]
