Hi all. I am writing a web app with a mysql back end and there is every chance one of the tables may have to handle 56+ million records. I am no mysql expert but has anyone else here ever handled that volume of data, and if so, any suggestions or caveats? The tables will of course be correctly indexed and the database normalised.
I know it's really a mysql question so apologies. -- http://www.web-buddha.co.uk