I have a database that I put together that is about 11+ Million Rows.
The .sql dump is about 2.5 gigs. I have done NO optimization to this
database yet - I want to make sure I'm doing the correct thing
Ideally I'd like to edit the .sql dump to create any indexes/
partitions that are needed, so that when I execute /. the script
everything will happen automatically.
I believe the two colums that will be searched upon most will be the
"name" column and "city" column, possibly a "state" column as well.
i.e. looking for "smith" in ...