Chris,
We run a large data warehouse with tables similar to yours. We basically gave up on
indexing and the overhead involved and just tablescan. The key is to partition the
data using a concept called Merge Tables. However, since we currently use Oracle,
eager to migrate to MySQL - I don't hav
Chris Fossenier writes:
... Query 1
> a1.phone_pander_flag <> 'Y'
> AND state.state = 'PA'
> AND ( h1.homeowner = 'Y'
> OR h2.probable_homeowner IN ('8','9')
> OR h2.homeowner_probability_model BETWEEN '080' AND '102' )
> AND ( p1c.exact_age BETWEEN '40' AND '60'
> OR estimated_age BETW
Disclaimer:
All you do with the suggestion in this mail is you responsibillity even
if your system will crash :)
-Original Message-
From: Chris Fossenier [mailto:[EMAIL PROTECTED]
Sent: maandag 23 februari 2004 18:16
To: [EMAIL PROTECTED]
Subject: MySQL versus M
nt: Monday, February 23, 2004 11:42 AM
To: Chris Fossenier; [EMAIL PROTECTED]
Subject: Re: MySQL versus MS SQL
Hi Chris,
Chris Fossenier wrote:
> This is a long post, my apologies.
Speaking for myself, I found the detail most helpful. Thanks!
See response at bottom.
...snip...
> QUER
Hi Chris,
Chris Fossenier wrote:
This is a long post, my apologies.
Speaking for myself, I found the detail most helpful. Thanks!
See response at bottom.
...snip...
QUERY1
~~~
Indexed Fields (link, phone_pander,state, exact_age, estimated_age, phone,
first, last, address)
MS SQL QUERY (
Hello,
This is a long post, my apologies.
I have been working on migrating a database from MS SQL to MySQL for about 1
month now and am at a point where I can start running some tests to see how
they compare. I'll provide a little background to help you out.
The MS SQL database is 120million
