2014
2010
2009
Hack Drupal core! | realize.be
by claire_
For a fairly large community site (think OG, node access control, private messages etc), we were getting in trouble giving authenticated users a decent browsing experience. The worst page was taking 16 (yes, sixteen) seconds to load and others were getting in trouble too now that the number of users and nodes was growing rapidly. Not acceptable of course, so we went searching for solutions:
2008
2007
2006
Simon's Software Stuff: SQL Server performance tips
by springnet
Does your SQL statement have a WHERE clause? I know this sounds obvious, but don't retrieve more data than you need. However, less obvious is that even if your SELECT statement retrieves the same quantity of data without a WHERE clause, it may run faster
Improve PHP Performance by Caching Database Results | Database Change Notification
by Xavier Lacot (via)
As is well known, caching the results of database queries can dramatically improve script execution time and minimize the load on the database server. This technique can be especially effective if the data you are dealing with is quite static. This is because many data requests to a remote database may be eventually satisfied from the local cache, thus avoiding the need to make a connection to the database, execute the query, and fetch the results.
1
(10 marks)
