Questions about database performance and tuning, ranging from files organization and configuration to benchmarking and system optimization, passing through management systems and the fastest ways to operate a database.
At what point does a MySQL database start to lose performance? Does physical database size matter? Do number of records …
mysql database database-performanceHow does the performance of the following two query components compare? LOWER LIKE ... LOWER(description) LIKE '%abcde%' ... iLIKE ... …
performance postgresql pattern-matching database-performanceI have a table with more than 100 millions rows in Innodb. I have to know if there is more than 5000 …
mysql sql count query-optimization database-performanceI'm trying to establish how much slower Entity Framework is over Stored Procedures. I hope to convince my boss to …
entity-framework stored-procedures performance-testing database-performanceI've been searching the web looking for best practices for configuring MongoOptions for the MongoDB Java driver and I haven't …
mongodb production-environment database-performance database-tuningI am trying to grasp the different concepts of Database Partitioning and this is what I understood of it: Horizontal …
database database-design database-performance sharding database-partitioningIn our product we have a generic search engine, and trying to optimze the search performance. A lot of the …
sql database oracle database-performance query-performanceWhat is the use of sp_updatestats? Can I run that in the production environment for performance improvement?
sql sql-server database-performanceWe're using Postgresql 9.1.4 as our db server. I've been trying to speed up my test suite so I've stared profiling …
postgresql database-performance truncateoI have a table with 2 millions of registers, but it will grow much more soon. Basically this table contains points …
mysql query-optimization database-performance