Re: Query speed problems
От | Victor Danilchenko |
---|---|
Тема | Re: Query speed problems |
Дата | |
Msg-id | Pine.OSX.4.50.0304181057350.567-100000@phobos.cs.umass.edu обсуждение исходный текст |
Ответ на | Re: Query speed problems ("Nikolaus Dilger" <nikolaus@dilger.cc>) |
Список | pgsql-performance |
On Thu, 17 Apr 2003, Nikolaus Dilger wrote: >Victor, > >What is the issue? You get sub second response time. The issue is that the query is a part of *user interface*, as I wrote in my original message; and there is a small number of such queries (about 3) that run per each user action. A second-long wait in *UI* is unacceptable -- people tend to find even third-of-a-second wait to be annoying. UI interactions should be so fast as to appear nearly instant. >Why waste your time trying to make it faster? Well, there's also the learning aspect of it -- this is my first major SQL project, and I am trying to understand as much as I can about under-the-surface stuff. Thanks to Peter Darley, I already have a fast solution -- now I simply want to understand more about the performance issues inherent in reverse-lookup subqueries. >If you have a query that runs serveral minutes or hours >then its worthwhile tuning. Or if your query gets >executed several thausend times a day. -- | Victor Danilchenko | Of course my password is the same as | | danilche@cs.umass.edu | my pet's name. My macaw's name was | | CSCF | 5-4231 | Q47pY!3, but I change it every 90 days. |
В списке pgsql-performance по дате отправления: