HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


large databases

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#33880 (In Topic #7650)
Avatar

Community saint

This is kind of a geeky thing but I was looking at my sql database and for the site that is in my siggy the database is over 120 mb in size making it hard to make a back up as the back up is now to large to restore and it makes my computer crash.

Any way I have been watching different tables like the posts, and translation table.
The translate is like this.
Space usage    Type     Usage
Data    2,644    KiB
Index    817,152    B
Total    3,442    KiB

The post is like this
Space usage    Type     Usage
Data    11,004    KiB
Index    8,313    KiB
Total    19,317    KiB

I am starting to wonder what will happen if those numbers get close to a gig and if any one has seen it get that high.
Ya I know I am a longs ways off and its going up slowly but it could get up that high if I keep adding things and content to the site.

I run http://otakuplayground.com and am hopping to make themes and other things for ocportal even though I no longer use it for otakuplayground.com I still love it and feel it could go far with the right help. It needs themes and needs people to advertise for it.
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: