Page 1 of 1

Database Size

Posted: Tue Mar 28, 2017 6:37 pm
by happydg
Hello,

For the same amount of galleries, thumbs, categories, models etc... the smartcj database is way bigger ( like 5 times ) than other scripts ( kvs, adultscriptpro, inxy.. ).

Is there any other way than optimize database to reduce size of the database?

Because if you want to run an aggregator like nudevista, the database would weight dozens of gigabytes.

Thank you.

Re: Database Size

Posted: Wed Mar 29, 2017 7:44 am
by admin
Lets see
Can you show a DB with 1k of galleries for any of those scripts ?

Re: Database Size

Posted: Wed Mar 29, 2017 12:54 pm
by happydg
For example with more than 40k videos and 6k models with adultcriptpro the database weights 40 mb.

For 12k videos on kvs the database weights 15 mb.

Re: Database Size

Posted: Wed Mar 29, 2017 1:54 pm
by admin
Sure, send me mysql dump
I'll compare it

Re: Database Size

Posted: Wed Mar 29, 2017 9:20 pm
by happydg
Sent.

Re: Database Size

Posted: Fri Apr 07, 2017 11:21 am
by admin
They don't have a lot of stats for thumbs
Actually it was quite a surprise for me, I thought that script was more advanced
Now I know SmartCJ is definitely the most advanced one.