I'm wondering about the performance of using one query versus several.
For instance, how much slower would several queries be:
SELECT name FROM table WHERE id=123;
SELECT value FROM table WHERE id=123;
SELECT type FROM table WHERE id=123;
As compared to one larger equivalent query:
SELECT name, value, type FROM table WHERE id=123;
It would be immensely easier for my application to use multiple small
queries so that it wouldn't need to worry about invalidating a cache
after a period of time, but if the performance hit would be too large,
I suppose I'll bite the bullet and write the annoying caching code.
pgsql-novice by date
|Next:||From: Kalyanaraman Rajaraman||Date: 2005-04-21 10:19:36|
|Subject: Transaction processing performance|
|Previous:||From: tövis||Date: 2005-04-20 22:04:17|
|Subject: localisation - collation sequencies|