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

Moving forward with Composr

ocPortal has been relaunched as Composr CMS. ocPortal 9 is superseded by Composr 10.

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

large databases

Login / Search

 [ Join | More ]
 Add topic 
#33880 (In Topic #7650)

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 and am hopping to make themes and other things for ocportal even though I no longer use it for 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: