Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
0 registered (), 33 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/02/04
Posts: 195
Top Posters (30 Days)
Ruben 51
DennyP 24
Gizmo 23
Dunny 16
SteveS 14
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 2 of 2 < 1 2
Topic Options
#183825 - 05/04/07 05:44 PM Re: Database size [Re: Rick]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
 Originally Posted By: Rick
The double storage is basically so we can offer more complex ubbcode. For example, the php markup. There is no way we could "uncode" that and end up with what the user typed in exactly.
Why not store the UBBCode in the database then parse it out when it's called?
_________________________
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
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."
#183835 - 05/04/07 06:30 PM Re: Database size [Re: Gizmo]
Yarp™ Offline
Registered: 08/30/06
Posts: 1513
Loc: Breda, NL
 Originally Posted By: Gizmo
Why not store the UBBCode in the database then parse it out when it's called?


Putting a post into the database happens once. Getting it out of the database happens about a three hundred billion gazillion times \:\)

I love the new way, it allows for lots of custom ubb code without loosing any performance. And all at the little cost of a little diskspace on your database server.
_________________________
Top
#183836 - 05/04/07 06:42 PM Re: Database size [Re: Yarp™]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
 Quote:
Putting a post into the database happens once. Getting it out of the database happens about a three hundred billion gazillion times \:\)


Couldn't have said it any better ;\)
Top
#183851 - 05/04/07 11:11 PM Re: Database size [Re: Rick]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Well the data is cached, so why not run the data through a custom function before the caching bits?
_________________________
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
#183871 - 05/05/07 11:23 AM Re: Database size [Re: Gizmo]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
The post body isn't cached, that's generated every time.
Top
#183880 - 05/05/07 06:34 PM Re: Database size [Re: Rick]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Was thinking you could serialize the content from the db as the cached content and parse it into the forum as an array; at least it made sense when I was on the john
_________________________
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
Page 2 of 2 < 1 2



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
Yesterday at 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10489 Members
36 Forums
33841 Topics
181706 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image