Quote:
Originally Posted by chrishirst
You want optimise the database.
Any particular database?
What is it used for?
How is it accessed?
How many tables?
How many records is it estimated that it will be used for?
Single user access?
Multi user access?
number of concurrent users?
Plus many other things than can have a bearing on how a DB could be optimised.
And you don't need a "webmaster" you need the services of a DBA.
|
I have planned to implement the website database by Mysql.
The database will be for slideshow images with title & description
Every slideshow will be containing 6 images
The dataset will be accessed via web
I am going to implement with 3 database tables
1 for images & its details
2 one for user registration
3 one for storing the details of slideshow clicks & ratings
In future, I have planned to add video section too
The database will be huge in size because of storing more & more images
It will be increasing its size rapidly
I have no idea which would be better, whether it’s single user or multi user?
Suggest me the optimum one
The concurrent users estimated is approximately 15000
and wanted to know what are the other things I have to focus. |
