|
|
Post by nagamerah on Jun 24, 2012 19:35:14 GMT -8
i have a suggestion, why don't adfoc separate 3 "connected" databases? as example, there will be 1 database for short url and another one is for user/publisher/advertiser database.. this way when there's maintenance on the user database, those shrink-ed link wont goes down as the user database, and the 3rd database will do its work when the user/publisher/advertiser is down, they will store the amount of clicks when its down
|
|
|
|
Post by AdFoc.us on Jun 25, 2012 12:08:31 GMT -8
Thanks for the suggestion.
Our database is big in size and has lots of data. We've been working hard making optimizations and re-structuring the database so there is less load on MySQL. The main thing is avoiding queries that evaluate LOTS of data. This has been a problem with our backup tool and our payment tool. To fix this we've been aggregating and caching the data 24/7 so this problem is avoided.
|
|
|
|
Post by nagamerah on Jun 27, 2012 3:54:35 GMT -8
yeah.. i kindda figure that out when we really can get lots of money from adfoc, i figure that you guys have LOTS of users and advertiser so ofcourse the database size will be HUGEEEE right.. im rooting for you guys, may you guys have a great coder to fix this issues
|
|
|
|
Post by AdFoc.us on Jun 27, 2012 13:28:56 GMT -8
Thanks!  We have a very talented developer who has been working with us the last few months and everything is going very well so far. |
|
