Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-performance]

185 questions
5
votes
4 answers

Speeding up SQL Server temp table processing with a RAM Disk

A system we are developing consists of a Web app frontend, and a backend that does a lot of data processing using stored procedures in SQL Server 2008 R2 (please, don't ask why...). These stored procedures make heavy use of temp tables (creation,…
mramirez
  • 51
  • 1
  • 4
5
votes
5 answers

PostgreSQL High Performance Setup

I am setting up a server with the following specs: * Qty 4 Processors (AMD Opterons with 12 cores each) * 32 GB Memory * Qty 8 HDD (15K SAS Dual Port) * CentOS 5.5 * JBoss * PostgreSQL It is likely that at a later point I will separate the…
user75452
  • 111
  • 1
  • 2
  • 3
5
votes
1 answer

PostgreSQL - count() performance and how to tweak it?

I've done some reading in google and the only thing I did was get myself confused. Some of the people say that count() is slower with many records, others say you can cache the number or even use sequence... What's the best way to count many rows…
tftd
  • 1,480
  • 7
  • 24
  • 38
5
votes
7 answers

Optimizing performance across thousands of SQL Server databases

We are building an application where each client will have their own database. None of the databases are particularly large (20MB to 400MB each), but there will be ~5,000 to start and at any one time 100 or so will be active. Our team has been…
Beep beep
  • 1,843
  • 2
  • 18
  • 33
5
votes
1 answer

Loading large CSV into Postgres

I'm trying to load a CSV of about 100M records (around 8GB on disk) into Postgres via the copy command: copy mytable from 'path/to/myfile.csv' with CSV; I have been monitoring the progress by checking the reported table size in pgAdmin and comparing…
G__
  • 294
  • 2
  • 9
4
votes
3 answers

mysql performance tuning, write, get db into ram

I am trying to improve the performance of a website by optimizing the Mysql server. In addition to general optimization I have a feeling that some write operations take an unacceptably long time. The server is a Mac os x server 10.5.8 (I think this…
tomsv
  • 273
  • 3
  • 8
4
votes
1 answer

Are there any performance differences between Oracle Entreprise and Oracle Standard editions?

Someone has asserted to me that the reason why one database is performing better than another (50-100%) is because one has Enterprise Edition and the other has Standard Edition. Given the same hardware, OS, versions and data - and only using the…
BIBD
  • 1,826
  • 10
  • 29
  • 44
4
votes
1 answer

Mysql InnoDB table size performance

I have a table that is closely approaching 2 million records. This table stores a history of transactions. This is on a high traffic website but also the table is not accessed regularly. We currently have no slow queries due to this table, but am…
pablo
  • 3,020
  • 1
  • 18
  • 23
4
votes
1 answer

Option shared_buffers in PostgreSQL

I have a server with 4GB of RAM and PostgreSQL 9.0.3 on Centos 5. I'm using pgbench and pgbench-tools to measure performance using two pgbench-tools queries: select and tpc-b. With default settings of postgresql.conf and using a select query, I get…
doctore
  • 143
  • 1
  • 4
4
votes
4 answers

MySQL, disk I/O and SSD drives

We have a LAMP box with 2x mirrored 1 TB WD Black Caviar disks running the whole OS and MySQL. 8 GB / RAM, 2x quad core CPUs. We're really taxed on disk I/O, and I've been thinking of suggesting getting a couple SSD drives in there for…
Stephen J. Fuhry
  • 154
  • 1
  • 8
4
votes
3 answers

MySQL maintenance - how to clear the buffer?

We have a server running our PHP/MySQL-based web application which is SLOW. My predecessor says: We used to do database maintenance, which used to clear the buffer, cached and unwanted variables. And I wonder what on earth he means with that…
Dougal
  • 43
  • 1
  • 1
  • 3
4
votes
2 answers

extreme slowness with a remote database in Drupal

We're attempting to scale our Drupal installations up and have decided on some dedicated MySQL boxes. Unfortunately, we're running into extreme slowness when we attempt to use the remote DB - page load times go from ~200 milliseconds to 5-10…
ceejayoz
  • 32,469
  • 7
  • 81
  • 105
3
votes
2 answers

MySQL LOAD DATA INFILE: Better Server, Worse Performance

I am testing out Microsoft Azure Database for MySQL and have run into a performance issue that I do not understand. I launched a "Basic" server with 1 vCore (2 GB RAM, "Standard Storage"), which is their lowest possible tier of server. I created a…
user3175864
  • 71
  • 4
3
votes
1 answer

Finding SQL Server Bottleneck - not CPU, IO, available memory

I'm trying to identify the bottleneck on a new SQL Server implementation (2012 Enterprise). I've been running some meaty queries/ETL jobs which are taking a considerable time - but I'm having difficulties identifying what is the limiting factor. The…
MikeBrom
  • 31
  • 3
3
votes
1 answer

Slow connection to Azure Sql Server

I'm moving from a Rackspace Cloud platform to Azure but I'm having some real performance issues. It seems like everything is a little but slower but especially database interaction. I've done some load testing with all the different Scale options…
Travis
  • 31
  • 1
  • 2
1
2
3
…
12 13