[pLog-svn] big LT database

[Jon Daley]

 	It is done!  I added a third generateData process, and the smaller 
set of indexes helped out as well.
 	I have a really slow broadband connection, so I will start the 
upload now, and if it isn't finished by tomorrow morning, I will probably 
end up burning a cd, but they don't like it when I use the work connection 
too much either.  But, we will see.



On Mon, 1 May 2006, Oscar Renalias wrote:

> I want that data :-) I will set it up in devel.lifetype.net for testing.
>
> 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.
>
> Oscar
>
> On 1 May 2006, at 19:07, Jon Daley wrote:
>
>> 	I am up to 8000 blogs, 21K users, 62K articles and 345K comments. It 
>> will be a couple days until it is 10K blogs, which I think is the goal.
>>
>> 	How many people want this data?
>>
>> 	What indexes should I put on the data - there currently aren't any, 
>> in order to speed the INSERT import.  Should I take the defaults from the 
>> wizard, and then apply what Christoph already recommended?
>>
>> 	I think giving you a zip files of .myi,myd, etc. files will be the 
>> quickest - does anyone not have access to their mysql directory, and so 
>> want the data zipped as a regular mysqldump.
>> 
>> 
>> 
>> **************************************
>> Jon Daley
>> http://jon.limedaley.com/
>> 
>> If anything just cannot go wrong, it will anyway.
>> -- Murphy's Fifth Law
>> _______________________________________________
>> pLog-svn mailing list
>> pLog-svn at devel.lifetype.net
>> http://devel.lifetype.net/mailman/listinfo/plog-svn
>> 
>
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn

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

Become a fixer, not just a fixture.
-- Anthony D'Angelo