"Thomas Munz" <[EMAIL PROTECTED]> writes:
> 100.000 entries less then the second one )
> is much slower then selecting all entries. This query was also 100 times
> executed with allways the same result.
>
> explain ANALYZE select * from hd_conversation where action_int is null limit
> 1552888;expl
Well, I did another check on the LIMIT function ( table has without
"where" statment more then 2.000.000 entries) :
select count(*) from hd_conversation where action_int is null;
count
-
1652888
(1 row)
So, I runned this query now. The query with limit ( which eaven should
select 10
Thomas Munz wrote:
Hello List!
I tried today to optmize in our companies internal Application the
querys. I come to a point where I tried, if querys with LIMIT are slower
then querys without limit
I tried following query in 8.2.4. Keep in mind that the table hs_company
only contains 10 rows
Hello List!
I tried today to optmize in our companies internal Application the
querys. I come to a point where I tried, if querys with LIMIT are slower
then querys without limit
I tried following query in 8.2.4. Keep in mind that the table hs_company
only contains 10 rows.
[EMAIL PROTECTED
