ReturnReturn to Article

Recommend Database Optimize patterns (Email)

This action will generate an email recommending this article to the recipient of your choice. Note that your email address and your recipient's email address are not logged by this system.

EmailEmail Article Link

The email sent will contain a link to this article, the article title, and an article excerpt (if available). For security reasons, your IP address will also be included in the sent email.

Article Excerpt:

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


Article Link:
Your Name:
Your Email:
Recipient Email:
Message: