[pLog-svn] big LT database

Jon Daley plogworld at jon.limedaley.com
Mon May 1 22:29:12 GMT 2006


 	Hrm - plog.log just got to 2 gigabytes, which is apparently the 
limit of ext3 files.
 	Does anyone care about the data that is in that file?

 	Also, I re-added the indexes to the all of the blogs, and it is 
now significantly faster, no surprise I guess.  Although it was also 
quicker to add them - I wonder if having all the extra indexes makes it 
harder to add other indexes?  It was really slow to add an index before, 
and now there is twice the data, and the indexes only took maybe 10 
seconds to add at the most, and usually much quicker than that.


On Mon, 1 May 2006, Jon Daley wrote:

> On Mon, 1 May 2006, Oscar Renalias wrote:
>> If you could add the indexes as per the db schema available in the install/ 
>> folder, that would be great. If not I can do it myself in 
>> devel.lifetype.net and offer the mysql files from there. As you wish.
> 	Yes, now that you checked in those changes, I will use that.
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn
>

**************************************
Jon Daley
http://jon.limedaley.com/

Happiness is not a station you arrive at, but a manner of traveling.
-- Margaret Lee Runbeck


More information about the pLog-svn mailing list