« The Future of the Parallelism and its Challenges | Main | non-sequential, unique identifier, strategy question »

Database Optimize patterns

Database Optimize patterns

Most of websites and enterprise application rely on the database backing them to store the application and customer data. So at some point the database could be the main performance and scalability bottleneck for your system performance, so I ‘m here today to cure this!

key points:

  • Database supporters and resisters:
    • Database supporters: MySQL, SQL Server, and PostgreSQL

    • Database resisters: HBase, MongoDB, Redis, and others

  • Database Optimizing pattern:
    • What to store into the Database?

    • Field data types

    • The primary key and the indexes

    • Data retrieve, SP’s, and Ad-hoc queries

    • Caching

Reader Comments (1)

MySQL is faster than MS SQL Server you say? Not in my experience - do you have any benchmark figures?

November 29, 1990 | Unregistered CommenterS

PostPost a New Comment

Enter your information below to add a new comment.
Author Email (optional):
Author URL (optional):
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>