Erin ONeill wrote:
> So Jay -- don't you want to work on some forums
> software?? :), if you know of one (even if it
> costs) that has a nice schema and doesn't make
> slow queries I'm ALL EARS! :)
Oh, come on. This is fun, not work! ;)
No, I'm not in the business of recommending one over the other...perhaps others could chime on on that. But, before they do, make sure they understand the load you're running. You don't want people saying "Oh, I use XXX because it's cool", but it flops over 100 simultaneous connections...
-------
As for the other stuff, I know I'm going to hate myself because I'm going to spend hours on this because I like the challenge, but go ahead and post the full SHOW CREATE TABLE for w3t_Users and w3t_Posts.
:)
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com