SQL_CALC_FOUND_ROWS in POSTGRESQL / Some one can helpe me.
От | Marcos Borges |
---|---|
Тема | SQL_CALC_FOUND_ROWS in POSTGRESQL / Some one can helpe me. |
Дата | |
Msg-id | 457814D3.1030001@mbsi.com.br обсуждение исходный текст |
Ответы |
Re: SQL_CALC_FOUND_ROWS in POSTGRESQL / Some one can helpe
|
Список | pgsql-performance |
<div style="padding-left: 20px; font-size: 92%; float: right; padding-bottom: 10px;">07/12/2006 04:31 </div><b>SQL_CALC_FOUND_ROWSin POSTGRESQL</b><br /><br /> In mysqln i m using the command SQL_CALC_FOUND_ROWS in follow sintax.<br/> SELECT SQL_CALC_FOUND_ROWS name, email, tel FROM mytable WHERE name <> '' LIMIT 0, 10<br /> to have therecorset data.<br /> and<br /> SELECT FOUND_ROWS();<br /> to have the total of registers found.<br /><br /> I dont wantto use the command count(*), because the performance will fall down, depending of the quantyt of tables and "joins".<br/><br /> The Data base postgresql have something similar ???<br /><br /><br /> ---------------------------------------------------------------------------------------------------<br/><br /><div style="padding-left:20px; font-size: 92%; float: right; padding-bottom: 10px;">07/12/2006 04:31 </div><b>SQL_CALC_FOUND_ROWSno POSTGRESQL</b><br /> Dúvida NINJA no POSTGRESQL<br /> No mysql utilizo o comando SQL_CALC_FOUND_ROWSna seguinte sintax<br /> SELECT SQL_CALC_FOUND_ROWS nome, email, telefone FROM tabela WHERE nome <>'' LIMIT 0, 10<br /> para obter o meu recordset<br /> e<br /> SELECT FOUND_ROWS();<br /> para obter o total de resgitrosque realmente existem em minha tabela condicionado pelo WHERE, sem ser limitado pelo LIMIT.<br /><br /> Não querousar o count(*) pois o desempenho cai dependendo da quantidade de tabelas selecionadas e quantidade de registros.<br/><br /><br /> O postgreSQL possui algo similar? Caso sim pode me informar qual e fornecer um exemplo. <br /><br/>
В списке pgsql-performance по дате отправления: