… respect and what works well for Oracle,MS SQL, PostgreSQL may not work … differences which can affect performance dramatically. The three main issues you should be concerned …table etc. Prefer full table scans to index accesses – For large data sets full table scans are often faster than range scans…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
… I feel really hopeful that Oracle will solve these issues, and it won’t…queries that have mostly very fast performance, and occasionally have much worse, and –… can see it clearly when I scan the slow query log: there …Quit; and Statistics; and similar no-tables, no-storage-engines queries are …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
….0 series. Also note the “Auto Increment Issue” is finally solved in 5.1 which …different applications work best on different database brands. Oracle‘s main database has a very competent … have a fairly large Innodb table (150GB) that is showing poor performance for full table scans. using O_DIRECT, …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…reason for the high write performance of earlier versions. Traditional …: As well as Adaptive Checkpointing, Oracle has also been working … be done by REPAIR TABLE. The table data page size … use MVCC to do index scans. Basically this means that … but this can become an issue if millions of rows are…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… carry new features or slight performance improvements, however these days … where there are no issues with packages consistency. Unfinished installations… but also updates system tables (if needed), scans all tables for consistency problems, … and MySQL-fork vendors – Oracle, MariaDB and Percona. By …
