Re: msg board with efficient threaded view design?

2001-08-27 Thread Grigory Bakunov

Date |Mon, 27 Aug 2001 14:14:22 -0700
>From |PR <[EMAIL PROTECTED]>

Hello!

P> I was wondering if anyone could point me to a message board (perl or php)
P> that has a very efficient database design to handle threaded views.  I know
P> that this is a difficult task under mysql and have seen the threads on
P> recursive queries, but I'd like to find some real life examples rather than
P> start completely from scratch.

P> I'm currently using wwwthreads, but under under really high user loads it
P> can get bogged down because of the number of queries it's making to get all
P> the replies in the proper threaded order.  I know UBB and vBulletin don't
P> do threaded views.  Has anyone seen one that handles threading reasonably
P> efficiently?

Check http://phorum.org/ - it's not big phorum system with 
threaded view and mysql as one of data storage.

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




msg board with efficient threaded view design?

2001-08-27 Thread PR

I was wondering if anyone could point me to a message board (perl or php)
that has a very efficient database design to handle threaded views.  I know
that this is a difficult task under mysql and have seen the threads on
recursive queries, but I'd like to find some real life examples rather than
start completely from scratch.

I'm currently using wwwthreads, but under under really high user loads it
can get bogged down because of the number of queries it's making to get all
the replies in the proper threaded order.  I know UBB and vBulletin don't
do threaded views.  Has anyone seen one that handles threading reasonably
efficiently?


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php