|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 16,304 Likes: 116
|
Joined: Jun 2006
Posts: 16,304 Likes: 116 |
UBB.T7 stores 2 copies of posts in the database, one formatted and one as it was entered
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 16,304 Likes: 116
|
Joined: Jun 2006
Posts: 16,304 Likes: 116 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 196
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 196 |
One version is the original post, and the other is the parsed version ie. Original [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 <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
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
Your database may be twice the size
BUT
This topic is twice as WIDE !!
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Stop using a horrible browser
|
|
|
|
Joined: Jun 2006
Posts: 16,304 Likes: 116
|
Joined: Jun 2006
Posts: 16,304 Likes: 116 |
Stop using a horrible browser god you're my hero
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
That sure sucks. But like it or not IE still has the lions share of usage.
Does look better on FF though.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I just upgraded to IE7 and still have this wide topic problem here.
I thought IE7 would have solved this problem?
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 16,304 Likes: 116
|
Joined: Jun 2006
Posts: 16,304 Likes: 116 |
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 %)
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
IE does some strange things with their CSS support. I'm reworking things for 7.1 to work around their goofiness
|
|
|
|
Joined: Jun 2006
Posts: 16,304 Likes: 116
|
Joined: Jun 2006
Posts: 16,304 Likes: 116 |
IE does some strange things with their CSS support. I'm reworking things for 7.1 to work around their goofiness You'd think they'd get with the programme and follow standards versus inventing their own out of the blue...
|
|
|
|
|
Test
by Phun - 05/28/2024 7:31 PM
|
|
1 members (Nightcrawler),
462
guests, and
130
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|