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
There are too many online users to list.
Control functions:

Quick reply   Contract

Your name:
Your message: