On Tue, Mar 25, 2008 at 2:11 PM, CZUCZY Gergely <gergely(dot)czuczy(at)harmless(dot)hu>
wrote:
> May I ask, do you have any indeces or a primary key on that table?
>
yes, i have both the index and primary key on a column "id",
and am doing the
SELECT count(id) from TABLE;
this is taking 3 seconds