ProjectEQ CVS

[Annihilator]

Originally Posted by Zandig

6 hours!
1091 of the database took me about 10 minutes to source tops. Although that is much longer than it used to take. I was thinking this was due to much more added to the public release of the database than was previously available?

Will have to try 1091a.

What kind of computer are you using that let you source 120MB of data in 10 minutes?!?!? The PC that I have dedicated to the Emu server isn't a speed demon by far but it's no snail. Old method only took me 2 minutes 40 seconds to do a complete source of the DB.

The biggest drawback is that the new method processes line by line rather than a complete table at at time.

I will try 1091a later and see how long it takes for me to source.

[cavedude]

Originally Posted by Annihilator

The biggest drawback is that the new method processes line by line rather than a complete table at at time.

1091a and all future versions will not.

[Annihilator]

No biggie.. I wasn't really complaining, just stating the time differences.

[Annihilator]

Originally Posted by cavedude

1091a and all future versions will not.

Thanks CD, all better now!

[Zandig]

Originally Posted by Annihilator

What kind of computer are you using that let you source 120MB of data in 10 minutes?!?!? The PC that I have dedicated to the Emu server isn't a speed demon by far but it's no snail. Old method only took me 2 minutes 40 seconds to do a complete source of the DB.

The biggest drawback is that the new method processes line by line rather than a complete table at at time.

I will try 1091a later and see how long it takes for me to source.

AMD FX-60
2 gigs ram
WinXP

...good to see 1091a is sourcing better.

[Annihilator]

Yep. Source time back down to a 2.5 minutes on a P4 3GHz with a gig of memory. Much improved.

[Bishop4351]

Not sure in windows but you can just for loop it to import the db's in linux with some thing simple like:

for file in *.*; do mysql peq < $file; done

This would also mean that every file in the folder was one you wanted in the db.

[cavedude]

I recommend everybody grab the newest commands.sql from CVS. In contains ALL EQEmu commands, their default access values, and a handy new description field with their descriptions.

[leslamarch]

CD,
I was just wondering if you could point me in the right direction for a change log for the database? Sorry if i missed it somewhere
Thanks
~LL~

[cavedude]

http://www.projecteq.net/phpBB2/view...c53dbc5bf86a99

Is as good as we'll get. It's a good overview of the changes, but if every change was documented, half of my time would be spent writing that up