For questions about making database queries run faster.
I have a large database application that uses mysqls query cache ability. I'd like to inspect the contents of the …
mysql query-optimization query-cacheI've written a little app that parses expressions into abstract syntax trees. Right now, I use a bunch of heuristics …
algorithm query-optimization boolean-expressionThe query: SELECT "replays_game".* FROM "replays_game" INNER JOIN "replays_playeringame" ON "replays_game"."id" = "replays_playeringame"."game_id" …
postgresql indexing query-optimization postgresql-performanceI have the following table in a MySQL database: CREATE TABLE `secondary_images` ( `imgId` int(10) unsigned NOT NULL AUTO_INCREMENT, `…
mysql database database-design indexing query-optimizationIn SQLite, given this database schema CREATE TABLE observations ( src TEXT, dest TEXT, verb TEXT, occurrences INTEGER ); CREATE UNIQUE INDEX …
sql sqlite query-optimizationI read that wrapping a lot of SELECT into BEGIN TRANSACTION/COMMIT was an interesting optimization. But are these commands …
sqlite transactions query-optimizationIn a typical many-many arrangement like this... Movies Actors Movies_Actors ------ ------ ------------- movie_ID actor_ID FK_movie_…
sql sql-server postgresql many-to-many query-optimizationI want to select the content of the column text from entrytable. EXPLAIN SELECT text FROM entrytable WHERE user = 'username' &…
mysql query-optimization explainI need your help to optimize the query to avoid using "Using filesort".The job of the query is to …
mysql performance optimization query-optimization filesortI have a table in an Oracle database with a timestamp column nextTime and a string column destName. There are …
sql oracle query-optimization distinct rownum