Results 1 to 2 of 2

Thread: ASP.NET Forums Question

  1. May 18th, 2003, 11:00 AM #1
    mpSmooth
    mpSmooth is offline

    Thread Starter
    Addicted Member
    Join Date
    Nov 2000
    Posts
    217

    ASP.NET Forums Question

    Hello, I'm trying to creat a forum using c# and I'm trying to receive the last post date and message from two tables. Topics and Replies (DateAdded & Message are the columns) . How can I query for this information. I've tried doing a union, but I can't get it to work.
    Reply With Quote Reply With Quote
  2. May 18th, 2003, 12:48 PM #2
    hellswraith
    hellswraith is offline
    PowerPoster hellswraith's Avatar
    Join Date
    Jul 2002
    Location
    Washington St.
    Posts
    2,464
    What I did for efficiency and speed is to store the last reply time (or the post time if it has no replies) in the topics table with the original post. When you get the list of topics, this will always be there and no complex unions and select statements to get it. Updating this information every time someone replies is more efficient than doing complex statements everytime it is shown.

    I know it isn't completely normalized, but it helps the query speed, and that was what I was looking for.

    www.variantx.com/VXForums/
    My Site
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width