October 1998
Intermediate to advanced
374 pages
12h 6m
English
Content preview from Web Performance TuningBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Performance Tips
Planning
A web site that exists for database access should be planned around the database. First, decide what sort of load the database will have to handle, and then choose web server software and hardware based on that load. The database will probably have to do much more work than the web server, so the database will be the bottleneck.
If you can afford to cache the whole database in RAM, a technique known as supercaching , do it. Also, if you know something about the kinds of SQL statements that will be executed, you can be ready for them with the correct amount of memory. Complicated joins take a lot of RAM and may even use all of your virtual memory if you’re not careful.
Database vendors have a natural advantage in providing the fastest drivers and connectivity for their databases, but the Java DataBase Connectivity standard ( JDBC™) does give you portability options. The best JDBC drivers talk directly to the database in the database’s native protocol. The Open DataBase Connectivity standard (ODBC) slows things down a bit.
Multiple Tiers
The browser/web server/database setup happens to be a three-tier system, but doesn’t have all the advantages of three-tier unless you plan for them. A two-tier system, where the web server is also the database, will give you better performance for small numbers of users but will not scale well. For large numbers of users, three-tier systems can reuse business objects on the web server or application server for both reading ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.