This all helps. I think I need to spend some time experimenting.
Thanks for your help!
- Ron
On 3/19/2010 3:56 PM, Bastien Koert wrote:
[snip]
Here's an example of a tough query (there are lots of Smiths!).
SELECT voter1.County, voter1.`First Name`, voter1.`Middle Name`,
voter1.`Last N
[snip]
> Here's an example of a tough query (there are lots of Smiths!).
>
> SELECT voter1.County, voter1.`First Name`, voter1.`Middle Name`,
> voter1.`Last Name`, voter1.`Residential ZipCode`,voter1.`House Number`,
> voter1.`Mailing Address`, voter1.`Street Name`, voter1.`Residential City`,
> vote
On 3/18/2010 4:59 PM, Chris wrote:
> What do your queries end up looking like?
Here's an example of a tough query (there are lots of Smiths!).
SELECT voter1.County, voter1.`First Name`, voter1.`Middle Name`,
voter1.`Last Name`, voter1.`Residential ZipCode`,voter1.`House Number`,
voter1.`Mailin
listread wrote:
Chris,
I just assumed that everyone on this list was using MySQL... That's
what we're using (v. 5.1.45 GA) with InnoDB as the engine.
Most people are but there are lots of types of databases out there :)
(I just read your tutorial at http://www.designmagick.com/article/16/
Chris,
I just assumed that everyone on this list was using MySQL... That's
what we're using (v. 5.1.45 GA) with InnoDB as the engine.
(I just read your tutorial at http://www.designmagick.com/article/16/
It was very helpful - I look forward to checking out more of your articles.)
If it is
listread wrote:
Greetings!
We are working on a 4 million record db with about 55 fields. We need
to build indexes to speed queries, but it seems to take way too long.
I'm assuming your using mysql but that's just a guess.
What database? (mysql, oracle, postgres, firebird, sqlite, other)
If
