Hello, can you please add more information - on what platform is the database running, type of the database and so on...?
Sure, you should explore:
- using indexes in mySQL: http://dev.mysql.com/doc/refman/5.7/en/mysql-indexes.html
- selecting an approppriate table type or storage engine: http://www.mysqltutorial.org/understand-mysql-table-types-innodb-myisam.aspx
Hello Landa,
If you are much concerned about the latency of loading a website, then you may look into NoSQL Databases like MongoDB. I think recent versions of MySQL supports NoSQL as well. Optimization is involved from the place of application development, by following best practices , deployment - Having Highly Available Clusters with proper load balancing etc. Hope this helps.
-
V.Srikrishnan
- Badges
- Science topic
- Similar topics
- Mathematical Sciences
- Graphs