Welcome to WebmasterWorld Guest from 54.234.190.237

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

3-4 Table JOIN?

     
6:48 pm on Apr 30, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Mar 4, 2004
posts:59
votes: 0


I'm working a custom built forum and would like to in one shot select the names of subject -> category -> forum -> and topic all at once?

For those who never looked at a webforum database .. my database setup - topic has subID of forum primary, forum has subID of category primary, and category has subID of subject primary.

So how may this look? Instead of running 4 queries back to back to back? I don't need all entries from all tables, just one feild each from the 3 other's and 2-3 from the topics table.

7:15 pm on May 2, 2005 (gmt 0)

Administrator

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 24, 2001
posts:15756
votes: 0


the 4 queries might actually be quicker, not sure, joining what could be the 4 biggest tables in the db could be somewhat nasty, though I guess most forum software is no stranger to nasty joins.

Are you changing this because it is too slow now?

have you had any success with any queries so far?

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members