Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

Database Size

+3 votes
asked Nov 11 in Q2A Core by Shrisun
I have 250mb MySQL space.

How many questions and answers can be added?
commented 5 days ago by arjunsuresh
You can move images to disk if DB space is an issue. If you do so, I guess 250 MB will be good enough for about 40k posts -- just an approximate guess.

3 Answers

+2 votes
answered 6 days ago by ProThoughts
It depends on many factors, if you allow images/files upload then 250MB is very less. Also depends of question/answer detail. more text, more space is required. If you feel it is not enough then better move to some reliable host.

commented 5 days ago by Shrisun
Can we create our own uploader, if the image is the issue and store image to other domain?
commented 5 days ago by ProThoughts
possible but it will be hard for you to maintain going forward.
+3 votes
answered 5 days ago by bluegenel
My database is currently at 315MB and holds about 175,000 posts in total.

The problem with saving images to disk and not the database, is you then also have to save avatars to disk. Which means if you run out of database space, you have a difficult job moving avatars to your new setup. And things get messy.

What I have done is save avatars to the database and set up an image uploader that saves to disk independently.

commented 5 days ago by bluegenel
Not a problem.
commented 5 days ago by ProThoughts
@ arjunsuresh, Cloudflare is also very good, it has more CDN locations(I guess 118) compared to Amazon CloudFront(100). Make sure CDN server is close to visitors of your site.

also keep checking CDN performance regularly.

I tried Akamai, CloudFront and Cloudflare they all are excellent.
+1 vote
answered 5 days ago by MONKEY
when a transfer is made. What folders should be moved? which are users and questions?
commented 4 days ago by bluegenel
The folder is set in the config file. Typically at root using the folder name 'images'. Which then holds images including avatars. You also need to go into the Stats page in the Admin Panel and set to save to disk.