Best way to know if there is a row
От | Martin Marques |
---|---|
Тема | Best way to know if there is a row |
Дата | |
Msg-id | 200409280955.23773.martin@bugs.unl.edu.ar обсуждение исходный текст |
Ответы |
Re: Best way to know if there is a row
Re: Best way to know if there is a row |
Список | pgsql-sql |
I have a bunch of queries in a system I'm finishing, and I bumped with a question on performace. Which is the best way to solve this: I need to know if there is at least one row in the relation that comes from a determinated query. Which is the best way to do this: (a) Build the query with "SELECT * ..." and after executing the query see if numRows()>0 (b) Build the query with "SELECT count(*) ...", fetch the row and see if count>0 I'm working with (a) because I see it better in performace, but I wanted to be sure the numRows() will actually give me the exact amount of rows (had some problems in the past with Informix). The aplication is written in PHP. -- 09:45:02 up 16 days, 3 min, 4 users, load average: 3.32, 2.69, 1.77 ----------------------------------------------------------------- Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral -----------------------------------------------------------------
В списке pgsql-sql по дате отправления: