[geeklog-devtalk] geeklog-devel digest, Vol 1 #379 - 4 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 (Tony Bibbs)
   2. Re: Re: Input From PJ of Groklaw (Dirk Haun)
   3. Re: Re: Input From PJ of Groklaw (Dirk Haun)
   4. Re: Re: Input From PJ of Groklaw (Dirk Haun)

--__--__--

Message: 1
Date: Fri, 20 Aug 2004 12:50:44 -0500
From: Tony Bibbs <tony at tonybibbs.com>
To: Peter Roozemaal <mathfox at xs4all.nl>
Cc: geeklog-devel at lists.geeklog.net
Subject: [geeklog-devel] Re: Input From PJ of Groklaw
Reply-To: geeklog-devel at lists.geeklog.net

Peter Roozemaal wrote:


> 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.


Using files versus a DB is the admin's decision.  In your case you'd 
clearly need the DB.


> 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.


Hrm, haven't thought about this much.  Deserves some more thought from 
all of us.  Also, have you turned on query caching in MySQL.  I'm 
guessing you have but that would help 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.


k, Let me know when you get it ready and I'll let you SCP it to one of 
our servers.

--Tony

--__--__--

Message: 2
From: "Dirk Haun" <dirk at haun-online.de>
To: <geeklog-devel at lists.geeklog.net>
Subject: Re: [geeklog-devel] Re: Input From PJ of Groklaw
Date: Fri, 20 Aug 2004 20:49:29 +0200
Organization: Terra Software Systems
Reply-To: geeklog-devel at lists.geeklog.net

Tony Bibbs wrote:


>> The regular

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

>> had more that 50 links. (footnotes and back).



>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.


There was a reason why I switched to have What's Related created
dynamically - but I can't remember it :-/

bye, Dirk


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


--__--__--

Message: 3
From: "Dirk Haun" <dirk at haun-online.de>
To: <geeklog-devel at lists.geeklog.net>
Subject: Re: [geeklog-devel] Re: Input From PJ of Groklaw
Date: Fri, 20 Aug 2004 20:46:38 +0200
Organization: Terra Software Systems
Reply-To: geeklog-devel at lists.geeklog.net

Peter Roozemaal wrote:


>We need a bit of help from your side in separating read-only database

>operations from operations that modify the database.


Btw, have you tried switching to InnoDB tables (instead of MyISAM)? This
seemed to help the guys over at macfixit.com

1.3.10 will use InnoDB tables on a fresh install (if the MySQL version
used does support them). A script to convert existing DBs is included.

bye, Dirk


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


--__--__--

Message: 4
From: "Dirk Haun" <dirk at haun-online.de>
To: <geeklog-devel at lists.geeklog.net>
Subject: Re: [geeklog-devel] Re: Input From PJ of Groklaw
Date: Sat, 21 Aug 2004 13:27:59 +0200
Organization: Terra Software Systems
Reply-To: geeklog-devel at lists.geeklog.net

I wrote:


>There was a reason why I switched to have What's Related created

>dynamically - but I can't remember it :-/


I remember now: The reason was that the 'related' field held not only the
actual links but also the HTML for them, i.e. the entire content of the
What's Related block. But of course that block could use different HTML
for different themes.

So the obvious solution would be to go back and use this field, but this
time only store the actual links in there. This would still require some
processing power when rendering the article, but it should be a lot less
than the regular expressions would need.

I'll look into it ...

bye, Dirk


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



--__--__--

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


End of geeklog-devel Digest