Coverter Report:

Do not post support requests, bug reports or feature requests. Discuss phpBB here. Non-phpBB related discussion goes in General Discussion!
Get Involved
Post Reply
a.somervell
Registered User
Posts: 4
Joined: Thu Jun 02, 2005 11:55 pm

Coverter Report:

Post by a.somervell » Fri Mar 30, 2007 2:12 am

I have a board with about 140,000 topics and 3m posts; Just took a P4 3.2ghz machine running NOTHING else other than the coversion process about 72hrs to do the conversion.

Started on the posts table at 300 rows/s and was down to 19 rows/s by the end.

I did a couple of table optimizations in the middle which seemed to make a small difference.

Its in the "Final Stage" at the moment but I certainly hope an insert (ie. New Thread or Post) isnt going to be that slow.

User avatar
bbrian017
Registered User
Posts: 720
Joined: Mon Mar 19, 2007 2:20 pm
Location: Canada
Contact:

Re: Coverter Report:

Post by bbrian017 » Fri Mar 30, 2007 2:41 am

72 hours... thats intense

a.somervell
Registered User
Posts: 4
Joined: Thu Jun 02, 2005 11:55 pm

Re: Coverter Report:

Post by a.somervell » Fri Mar 30, 2007 2:50 am

Coversion all went sweet apparently, but browse to the front page and all I get nothing, blank page, no response headers, nothing.

*sigh*

a.somervell
Registered User
Posts: 4
Joined: Thu Jun 02, 2005 11:55 pm

Re: Coverter Report:

Post by a.somervell » Fri Mar 30, 2007 2:57 am

*Deleting the cache files solved that one...

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29253
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Re: Coverter Report:

Post by Marshalrusty » Fri Mar 30, 2007 5:57 am

I don't know what your settings are, but it didn't take nearly as long to convert the database here, which is comparable in size.
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

User avatar
david63
Registered User
Posts: 16696
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Coverter Report:

Post by david63 » Fri Mar 30, 2007 7:16 am

I would be interested to know how long the search index rebuild takes as in my experience this takes longer than the conversion.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

User avatar
Bobby_Boucher
Registered User
Posts: 61
Joined: Mon Jan 10, 2005 7:27 pm

Re: Coverter Report:

Post by Bobby_Boucher » Fri Mar 30, 2007 7:47 pm

Where is this conversion script?
Is there any documentation on how to use it?

Veskit
Registered User
Posts: 37
Joined: Mon Sep 13, 2004 5:46 pm

Re: Coverter Report:

Post by Veskit » Fri Mar 30, 2007 7:52 pm

built into beta 5 in the install directory

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29253
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Re: Coverter Report:

Post by Marshalrusty » Sat Mar 31, 2007 6:15 am

david63 wrote: I would be interested to know how long the search index rebuild takes as in my experience this takes longer than the conversion.

It may, yes, but not by much.

The convertor is in Beta5, however large chunks have been completely rewritten since then. If you're going to be testing it, I'd suggest trying a copy from a more recent CVS checkout or snapshot (both available on area51.phpbb.com). Documentation is limited during the Beta phase. Keep in mind that all parts of the Beta are for testing purposes only.
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

a.somervell
Registered User
Posts: 4
Joined: Thu Jun 02, 2005 11:55 pm

Re: Coverter Report:

Post by a.somervell » Tue Apr 03, 2007 11:09 am

Marshalrusty - Very standard install of... well everything from the ground up

Happy to give a new conversion script a go and give the dev team any details they might want

muse-ic
Registered User
Posts: 77
Joined: Wed Jun 30, 2004 12:21 am

Re: Coverter Report:

Post by muse-ic » Tue Apr 03, 2007 3:21 pm

prune?

Post Reply

Return to “phpBB Discussion”