Re: typical schema for a forum?
От | PFC |
---|---|
Тема | Re: typical schema for a forum? |
Дата | |
Msg-id | op.tr10w1ljcigqcu@apollo13 обсуждение исходный текст |
Ответ на | typical schema for a forum? (Louis-David Mitterrand <vindex+lists-pgsql-general@apartia.org>) |
Список | pgsql-general |
I have written a little PHP+postgres forum for benchmarking purposes, to see how fast postgres could go. It has basic forum features, like forums (duh), topics, posting, pagination, watching topics, topic & post count, display newest topic and post in topic & forum pages, templates, topics pagination in O(1) not O(number of pages), etc. I also wrote a companion benchmark script which tortures the server with HTTP requests, viewing and posting. it answered my "how fast can it go" question : more than 500 dynamic pages/second on a Core 2. Most of the load is PHP : postgres could handle much, much more than this. If people are interested in this as a benchmark, I can write some docs (and make a MySQL version). If you want to use it as a base for your forum, you're welcome. Who wants the source ? On Wed, 09 May 2007 10:49:17 +0200, Louis-David Mitterrand <vindex+lists-pgsql-general@apartia.org> wrote: > Hi, > > I'm trying to implement a forum with mason and postgresql. What is the > typical database schema of a forum (threaded or flat) application? > > Thanks, > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend
В списке pgsql-general по дате отправления: