[geeklog-devtalk] geeklog-devel digest, Vol 1 #378 - 5 msgs

[geeklog-devel-request at lists.geeklog.net]

Send geeklog-devel mailing list submissions to
	geeklog-devel at lists.geeklog.net

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.geeklog.net/listinfo/geeklog-devel
or, via email, send a message with subject or body 'help' to
	geeklog-devel-request at lists.geeklog.net

You can reach the person managing the list at
	geeklog-devel-admin at lists.geeklog.net

When replying, please edit your Subject line so it is more specific
than "Re: Contents of geeklog-devel digest..."


Today's Topics:

   1. Re: Input From PJ of Groklaw (Blaine Lang)
   2. Re: Input From PJ of Groklaw (Tony Bibbs)
   3. Re: Re: Input From PJ of Groklaw (Vincent Furia)
   4. Re: Input From PJ of Groklaw (Blaine Lang)
   5. Re: Input From PJ of Groklaw (Peter Roozemaal)

--__--__--

Message: 1
From: "Blaine Lang" <geeklog at langfamily.ca>
To: <geeklog-devel at lists.geeklog.net>
Subject: Re: [geeklog-devel] Input From PJ of Groklaw
Date: Fri, 20 Aug 2004 12:04:16 -0400
Reply-To: geeklog-devel at lists.geeklog.net

I wonder if we should consider implementing the PEAR Text_Wiki class
http://pear.php.net/package/Text_Wiki/

More details found on this page:
http://wiki.ciaweb.net/yawiki/index.php?area=Text_Wiki

It is not a full wiki and only does the transformation to the target output.

Blaine

----- Original Message ----- 
From: "Dirk Haun" <dirk at haun-online.de>
To: <geeklog-devel at lists.geeklog.net>
Sent: Friday, August 20, 2004 11:59 AM
Subject: Re: [geeklog-devel] Input From PJ of Groklaw



>4) She would like quotations, blocks of text in an article, to

>optionally have a slightly darker shading than the rest of the page, so

>it would be clearly a quotation, without having to use quotation marks.


Is this meant for articles only? Or also for comments? For articles
posted by moderators, a workaround using <span class="quote"> and some
CSS would do the trick. This is, of course, probably too complicated for
the normal user.

bye, Dirk


-- 
http://www.haun-online.de/
http://www.haun.info/

_______________________________________________
geeklog-devel mailing list
geeklog-devel at lists.geeklog.net
http://lists.geeklog.net/listinfo/geeklog-devel


--__--__--

Message: 2
Date: Fri, 20 Aug 2004 11:08:16 -0500
From: Tony Bibbs <tony at tonybibbs.com>
To: geeklog-devel at lists.geeklog.net
Subject: Re: [geeklog-devel] Input From PJ of Groklaw
Reply-To: geeklog-devel at lists.geeklog.net

Would this be worth while?

http://pear.php.net/package/HTML_BBCodeParser

It might be a suitable way for hacking around the crap I use for images 
in articles.

--Tony

Blaine Lang wrote:


>I wonder if we should consider implementing the PEAR Text_Wiki class

>http://pear.php.net/package/Text_Wiki/

>

>More details found on this page:

>http://wiki.ciaweb.net/yawiki/index.php?area=Text_Wiki

>

>It is not a full wiki and only does the transformation to the target output.

>

>Blaine

>

>----- Original Message ----- 

>From: "Dirk Haun" <dirk at haun-online.de>

>To: <geeklog-devel at lists.geeklog.net>

>Sent: Friday, August 20, 2004 11:59 AM

>Subject: Re: [geeklog-devel] Input From PJ of Groklaw

>

>

>  

>

>>4) She would like quotations, blocks of text in an article, to

>>optionally have a slightly darker shading than the rest of the page, so

>>it would be clearly a quotation, without having to use quotation marks.

>>    

>>

>

>Is this meant for articles only? Or also for comments? For articles

>posted by moderators, a workaround using <span class="quote"> and some

>CSS would do the trick. This is, of course, probably too complicated for

>the normal user.

>

>bye, Dirk

>

>

>  

>



--__--__--

Message: 3
Date: Fri, 20 Aug 2004 12:22:40 -0400
From: Vincent Furia <vfuria at gmail.com>
To: geeklog-devel at lists.geeklog.net
Subject: Re: [geeklog-devel] Re: Input From PJ of Groklaw
Reply-To: geeklog-devel at lists.geeklog.net

On Fri, 20 Aug 2004 17:46:41 +0200, Peter Roozemaal <mathfox at xs4all.nl> wrote:

> The database is the most serious performance bottleneck. We have 7?

> webservers talking to a single database and Geeklog does a lot of

> queries per page. We have a few stories with over 1000 comments!

> 


I implemented tons of changes in current CVS (1.3.10) that will reduce
the number of DB queries by a LOT.  Many (but by no means all) of
these changes were to comments and articles which reduces query time
by an order of magnitude for stories with lots of comments.  Now one
query will fetch all the comments and a typical article page load has
fewer than 50 queries (as opposed to about 150 (+ 1 per comment)  in
1.3.9).

Of course more testing will be required before I'd recommend throwing
these on a production system (especially Groklaw).

-Vinny

--__--__--

Message: 4
From: "Blaine Lang" <geeklog at langfamily.ca>
To: <geeklog-devel at lists.geeklog.net>
Subject: Re: [geeklog-devel] Input From PJ of Groklaw
Date: Fri, 20 Aug 2004 12:33:18 -0400
Reply-To: geeklog-devel at lists.geeklog.net

I think I looked at this some months ago ... it does not include the
formatting for quotes other then the " type <q>

Blaine
----- Original Message ----- 
From: "Tony Bibbs" <tony at tonybibbs.com>
To: <geeklog-devel at lists.geeklog.net>
Sent: Friday, August 20, 2004 12:08 PM
Subject: Re: [geeklog-devel] Input From PJ of Groklaw


Would this be worth while?

http://pear.php.net/package/HTML_BBCodeParser

It might be a suitable way for hacking around the crap I use for images
in articles.

--Tony

Blaine Lang wrote:


>I wonder if we should consider implementing the PEAR Text_Wiki class

>http://pear.php.net/package/Text_Wiki/

>

>More details found on this page:

>http://wiki.ciaweb.net/yawiki/index.php?area=Text_Wiki

>

>It is not a full wiki and only does the transformation to the target

output.

>

>Blaine

>

>----- Original Message ----- 

>From: "Dirk Haun" <dirk at haun-online.de>

>To: <geeklog-devel at lists.geeklog.net>

>Sent: Friday, August 20, 2004 11:59 AM

>Subject: Re: [geeklog-devel] Input From PJ of Groklaw

>

>

>

>

>>4) She would like quotations, blocks of text in an article, to

>>optionally have a slightly darker shading than the rest of the page, so

>>it would be clearly a quotation, without having to use quotation marks.

>>

>>

>

>Is this meant for articles only? Or also for comments? For articles

>posted by moderators, a workaround using <span class="quote"> and some

>CSS would do the trick. This is, of course, probably too complicated for

>the normal user.

>

>bye, Dirk

>

>

>

>


_______________________________________________
geeklog-devel mailing list
geeklog-devel at lists.geeklog.net
http://lists.geeklog.net/listinfo/geeklog-devel


--__--__--

Message: 5
Date: Fri, 20 Aug 2004 18:29:36 +0200
From: Peter Roozemaal <mathfox at xs4all.nl>
To: Tony Bibbs <tony at tonybibbs.com>
CC: geeklog-devel at lists.geeklog.net
Subject: [geeklog-devel] Re: Input From PJ of Groklaw
Reply-To: geeklog-devel at lists.geeklog.net

Tony Bibbs wrote:


>> The database is the most serious performance bottleneck. We have 7?

>> webservers talking to a single database and Geeklog does a lot of

>> queries per page. We have a few stories with over 1000 comments!

> 

> Yeah, this is clearly a problem.  We have recently implemented use of 

> PHP sessions.  We didn't do much with it other than store important 

> things like $_USER in it but now that we have that we need to 

> investigate using the single query made to populate $_SESSION form the 

> database in ways that will prevent the lots of little queries that have 

> cluttered the code.  Given that we need to start reviewing the code again.


PHP session variables create a load on the central file server. We can
not store them locally on the webserver as the loadbalancer will move
sessions from machine to machine. (rethinks) It might be possible if the
session variable only serves as cache for database data.


> Also, have you considered adding another database server and load 

> balancing them?  I think MySQL's replication has reached a point were 

> you could do this reliably.  Obvious it makes things more complex from 

> the administration side but it might be worth investigating.


We need a bit of help from your side in separating read-only database
operations from operations that modify the database. The config files
would need two database names, etc.


>> Another issue is that regular expressions can take huge amounts of CPU

>> time when stories go large. PJ writes stories that don't allways fit in

>> 64k, so I enlarged the bodytext field to mediumtext (16M). The regular

>> expression match in COM_extractLinks caused a time-out in stories that

>> had more that 50 links. (footnotes and back). BTW, we dropped the

>> "what's related" box.

> 

> Hrm, good idea. Dirk, it might be worth upgrading that field.  Yeah, the 

> regex's would be a killer on larger stories.  Thanks, we'll review it 

> and see how we can fix this.

> 

>> I have been looking for a suitable platform, but couldn't find another

>> one that

>>  1. was open source

>>  2. had a decent security record

>>  3. could be installed easily

>>  4. had a good management interface

>> and I'ld hate to convert databases to a new environment.

> 

> Well, like I said, we want to be sure that Geeklog grows as the needs of 

> the communities grow.  Groklaw is an outlier in terms of size but our 

> goal is to support sites that become this successful.  I hope that by 

> working together we can get to a point where Geeklog is sleeker, meaner 

> and cleaner.  All this reminds me of where Mozilla is with Thunderbird 

> and Firefox.  I think Geeklog is to a point where we need to bust out 

> with code analyzing an realling streamlining things.  Any chance we 

> might be able to get a copy of the Groklaw DB?  I know that is asking a 

> lot but it would help us a lot.


I can give you a sanitized version of the database if there is a place
where I can upload a 45 Mbyte of compressed data. I need a few hours to
clean it from personal data.

Greetings,
	Peter.




--__--__--

_______________________________________________
geeklog-devel mailing list
geeklog-devel at lists.geeklog.net
http://lists.geeklog.net/listinfo/geeklog-devel


End of geeklog-devel Digest