New MySQL database for 7.02 twice the size of 6.5.1 - UBB.threads PHP Forum Software Community

You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » Importer Assistance » New MySQL database for 7.02 twice the size of 6.5.1

Site Links

Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com

Top Posters (30 Days)

Ruben	49
Gizmo	24
DennyP	24
Dunny	17
SteveS	14
AllenAyres	12
dbremer	10
drkknght00	9
SD	9
driv	8

Latest Photos

Basildon Town Centre looking from the rounderbout

Page 1 of 2

Topic Options

#168924 - 11/24/06 02:18 AM

New MySQL database for 7.02 twice the size of 6.5.1

ntdoc

Registered: 11/09/06
Posts: 3384

I created an all new database in MySQL 5.0.27 for my new UBBT 7.02 install.

I installed UBBT 7.02 just fine and did the import of my old UBBT 6.5.1 and now looking at the folders for MySQL databases I see that my 6.5.1 folder size is much smaller.

6.5.1 = 160MB
7.02 = 352MB

Curious why the new database size is so much larger and if there is anyway for me to decrease it's size.
�

Top

Express Hosting

Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."

#168925 - 11/24/06 02:19 AM

Re: New MySQL database for 7.02 twice the size of 6.5.1 [Re: ntdoc]

Gizmo

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA

UBB.T7 stores 2 copies of posts in the database, one formatted and one as it was entered

_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!

Top

#168927 - 11/24/06 02:28 AM

Re: New MySQL database for 7.02 twice the size of 6.5.1 [Re: Gizmo]

ntdoc

Registered: 11/09/06
Posts: 3384

Thanks for the quick answer. Sorry for what may be a noob question, but why does it store the 2 copies.

There must be a valid reason why the new version stores it this way and I'm curious why or if there is a use for me as an Admin of the site.
�

Top

#168929 - 11/24/06 06:40 AM

Re: New MySQL database for 7.02 twice the size of 6.5.1 [Re: ntdoc]

Gizmo

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA

Originally Posted By: ntdoc

Thanks for the quick answer. Sorry for what may be a noob question, but why does it store the 2 copies.

Oh Rick lol...

I'm not sure, I think it was a speed/processing reason, Rick'd know best.

Top

#168939 - 11/24/06 10:12 AM

Re: New MySQL database for 7.02 twice the size of 6.5.1 [Re: Gizmo]

Ian Spence Offline

Registered: 06/04/06
Posts: 255

One version is the original post, and the other is the parsed version

ie.
Original

Code:

[quote=ntdoc]Thanks for the quick answer.  Sorry for what may be a noob question, but why does it store the 2 copies.[/quote] 

Oh Rick lol...

I'm not sure, I think it was a speed/processing reason, Rick'd know best.

Parsed

Code:

<div class="ubbcode-block"><div class="ubbcode-header">Originally Posted By: ntdoc</div><div class="ubbcode-body">Thanks for the quick answer.  Sorry for what may be a noob question, but why does it store the 2 copies.</div></div> <br /><br />Oh Rick lol...<br /><br />I'm not sure, I think it was a speed/processing reason, Rick'd know best.

It's done because otherwise, you'd have two options
1) Parse on the fly - this ends up slowing page loads
2) Parse once and only have that copy - this is a problem for editing and quoting, since a lot of work has to be done to figure out what you originally posted.

So instead, it's parsed and stored, as well as having the original stored. that way if you go to edit or quote, you just grab the default, and when you view a post, you just grab the parsed

Top

#168951 - 11/24/06 01:46 PM

Re: New MySQL database for 7.02 twice the size of 6.5.1 [Re: Ian Spence]

Mark S Offline

Carpal Tunnel

Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK

Your database may be twice the size

BUT

This topic is twice as WIDE !!

_________________________
Version v7.5.6

< Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.

Top

#168953 - 11/24/06 01:52 PM

Re: New MySQL database for 7.02 twice the size of 6.5.1 [Re: Mark S]

Rick

Post-a-holic

Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA

Stop using a horrible browser $\:D$

Top

#168965 - 11/24/06 04:16 PM

Re: New MySQL database for 7.02 twice the size of 6.5.1 [Re: Rick]

Gizmo

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA

Originally Posted By: Rick

Stop using a horrible browser $\:D$

god you're my hero

Top

#168970 - 11/24/06 04:50 PM

Re: New MySQL database for 7.02 twice the size of 6.5.1 [Re: Gizmo]

ntdoc

Registered: 11/09/06
Posts: 3384

That sure sucks. But like it or not IE still has the lions share of usage.

Does look better on FF though.
�

Top

#168971 - 11/24/06 04:56 PM

Re: New MySQL database for 7.02 twice the size of 6.5.1 [Re: ntdoc]

Daryl Fawcett Offline

addict

Registered: 06/05/06
Posts: 469
Loc: Canada

I just upgraded to IE7 and still have this wide topic problem here.

I thought IE7 would have solved this problem?

Top

#168973 - 11/24/06 05:08 PM

Re: New MySQL database for 7.02 twice the size of 6.5.1 [Re: Daryl Fawcett]

ntdoc

Registered: 11/09/06
Posts: 3384

No, Microsoft is part of the issue, but now days I think all of them do it. They all try to offer features that are not an "approved" standard so they deviate a little bit by using their own tags.

There are sites that don't look good in FF too. Doubt the issue will ever be resolved.

Top

#168975 - 11/24/06 05:19 PM

Re: New MySQL database for 7.02 twice the size of 6.5.1 [Re: Daryl Fawcett]

Gizmo

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA

IIRC IE doesn't respect the css rick is using; i believe he said he's reworkign it...

Also, on my site, IE users are down to 56.6 % (with FFox up to 28.9 %)