Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - Should I do a join on forum_topics?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Should I do a join on forum_topics?

 Post Reply Post Reply
Author
Joeee View Drop Down
Newbie
Newbie
Avatar

Joined: 05 August 2003
Status: Offline
Points: 33
Post Options Post Options   Thanks (0) Thanks(0)   Quote Joeee Quote  Post ReplyReply Direct Link To This Post Topic: Should I do a join on forum_topics?
    Posted: 26 January 2004 at 7:30pm

Hi everyone,

I'm trying to break up the forum_topics.asp page into multiple groups and was hoping for some advice on how to do it most efficiently. Specifically, I want to filter the results of TopicDetialsAll and TopicDetialsInTheLastXX sp's by those questions where the original author is also the last poster on that topic... so, I need to grab and compare the first and last record of everything in the Thread table that meets my topic requirements.

I see 2 ways.

1. Keep the select/stored procedure the way it is and then only show the topics that meet my criteria... or

2. Change the select/stored procedures to only get the records I need.

I'm playing with the 2nd idea now (since it seems the most logical) but I'm worried that the join will slow things down more than the quick data grab and filter concept.

The problem I see with #2 is that I'm turning a simple select on a big table into a many-to-many on 2 (or 3 if I can't figure out a way to stop selecting the thread table against itself) big tables... which could dramatically slow things down...

Any help would be greatly appreciated!



Edited by Joeee
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.