[thelist] Very Large MySQL Table

Fred Jones fredthejonester at gmail.com
Sat Mar 7 16:36:12 CST 2009


On Wed, Feb 11, 2009 at 3:01 AM, Phil Turmel <pturmel-webdev at turmel.org> wrote:
...
> May I suggest grep?

I wanted to follow up (yes, a month later) and say that this solution
worked for me. Using MySQL I ran into problems even just to massage
the data a bit before running my searches. The table was so big that I
couldn't even delete or update rows. So I processed the original input
file using PHP and generated a new text file with "massaged" data and
then made a little php script using shell_exec to run grep and it
works beautifully.

Thank you!



More information about the thelist mailing list