database performance

My database has table name transactions which has 20000 records. When i run this query SELECT T1.* FROM transactions AS T1 WHERE T1.ppno IN (SELECT…

We are at the begining of a new project, and we are really wondering if we should use stored procedures in MySQL or not. We would use the stored…

Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the…

I am a database designer with an existencial doubt. If you have a table1 that must have a relation with table2 or (exclusive or, one or another)…

I am a data base admin and developer in MySQL. I have a couple of years working with MySQL. I recently adquire and study O'Reilly High Performance…

I am developing a issue logger for my project and am running into an issue when analyzing the logged data. The problem being that this table grows…

I have a transaction that does one read on the database, followed by one write. If i choose MyIsam as my database engine in MySql does the table…

I have a database that is about 20 GB in size. I want to know if there are any optimization tips specific to working with a database that is static.…

Simple question. Wondering if a long IN clause is a code smell? I don't really know how to justify it. I can't put my finger on why smells other…

I created an inventory system which mostly is using a server-sided scripting language to do all the work. To try and get some performance gains I am…

What are some DOs and DONTs for improving database performance using index? A DO would be a case in which an index should be created, or another…

Apart from creating indexes on columns that are retrieved often, and doing SELECT col1, col2, col3 FROM tbl instead of SELECT * FROM table , what…

Hi, I have a postgresql DB with > 3 million rows in two tables. Something slows down the whole performance, so I analyzed a bit with the Ubuntu…

How can I reduce DB values? Anybody have any idea what is going on here? Completed in 0.19635 (5 reqs/sec) | Rendering: 0.00046 (0%) | **DB: 0.04554…

My Postgresql Data is under /mnt/pg_data/9.0/main/. So, I have two postgresql.conf files. One under /mnt/pg_data/9.0/main/ directory and the other…

I have a query that selects a table of nodes, then joins a table of titles to it. This is done by first joining an in-between table of node IDs and…

We have a data warehouse with denormalized tables ranging from 500K to 6+ million rows. I am developing a reporting solution, so we are utilizing…

This may be asked before, but here's the situation anyway. I have one big table (on MySQL using InnoDB), that is basically a huge log, no relational…

Hi, I am looking at some PostgreSQL table creation and I stumble upon this CREATE TABLE ( ... ) WITH ( OIDS = FALSE ); I read the documentation…

What would be faster in terms of performance and usability of editing etc. Storing the settings for widget in a file or storing the settings for it…