public marks

PUBLIC MARKS with tags performance & sql

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.

PUBLIC TAGS related to tag performance

cache +   cleverplanet +   database +   dba +   development +   drupal +   explain +   howto +   index +   join +   limit +   mysql +   optimization +   oracle +   php +   rapidité +   reference +   sgbd +   springnetdelicious +   sql +   sqlserver +   union +   upsert +   webdev +  

Active users

ghis
last mark : 06/03/2014 22:52

dzc
last mark : 18/02/2010 14:57

claire_
last mark : 17/04/2009 15:35

Elryk
last mark : 18/01/2008 23:57

jmfontaine
last mark : 03/10/2007 14:31

kemar
last mark : 13/03/2007 10:45

Ganf
last mark : 20/09/2006 09:40

sunny
last mark : 01/09/2006 12:04

springnet
last mark : 12/07/2006 12:20

Xavier Lacot
last mark : 07/07/2006 01:32