May 10, 2005 at 2:48 pm
Hello
Does anyone have an idea about the performance issues regarding JOIN's?
If I have two tables
UID | INFO
UID | INFO2
and the two of these are over a million records, being hit regularly but
10's of thousands of web users. Every record in the second DB is scanned
every night to see what is in INFO2. That is the reason for separation of
INFO and INFO2
What kind of impact would I have selecting INFO1 and INFO2 using a JOIN?
and
Is this silly to think this is possible?
Thanks in advance
Stefan
May 11, 2005 at 2:21 am
May 11, 2005 at 8:57 pm
From the little bit of information you gave it's hard to say for sure. It would depend a lot on how many columns, what your indexes are, etc. You can improve performance though by separating the tables into two different file groups and having each of those filegroups reside on different physical drives or better yet drive arrays. If you are able to move the indexes for each table on to separate drives as well you can gain additional performance. The architecture of your sub-system is going to play a big part in this as well (what type of drives, IO, etc.) . If you are able to break the tables down using some type of horizontal partitioning you probably have a better chance of returning the data in a timely manor than you would by lumping it all together. Good luck.
john
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply