Top "Database-tuning" questions

deals with optimizing the performance of a database.

How can I time a code segment for testing performance with Pythons timeit?

I've a python script which works just as it should, but I need to write the execution time. I've googled …

python testing timeit database-tuning
Optimise PostgreSQL for fast testing

I am switching to PostgreSQL from SQLite for a typical Rails application. The problem is that running specs became slow …

sql database performance postgresql database-tuning
How to configure MongoDB Java driver MongoOptions for production use?

I'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-tuning
How to profile MySQL

How do I profile a MySQL database. I want to see all the SQL being run against a database. I …

mysql sql profiling database-tuning
SQL Server audit logout creates huge number of reads

I'm using SQL Server Profiler to figure out what process are consuming SQL process and I found that the event …

sql sql-server sql-server-2008 database-tuning sql-tuning
Speed up Oracle Text indexing or let the indexer work only on low load times

We're using a Oracle Text CTXSYS.CONTEXT index to index about half a million rows containing metainformation. The information is …

oracle full-text-indexing database-tuning
Optimal JVM settings for Cassandra

I have a 4 node cluster with 16 core CPU and 100 GB RAM on each box (2 nodes on each rack). As of …

cassandra jvm database-tuning cassandra-2.1
Amazon RDS (PostgreSQL): Optimize memory usage

There is something i did not really understand with Amazon RDS (the PostrgreSQL version). Some queries takes a lot of …

performance postgresql amazon-rds database-tuning
Optimizing mysql my.cnf - memory usage is dangerously high

I have tunet up mysql by following some tips on the internet. but the websites are loading slow and time …

mysql linux performance mariadb database-tuning