Printable View
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.
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/