---In firebird-support@yahoogroups.com, <jegaza@...> wrote :
 
>> Here you delete some records, but then count whole table.
>>Add same "where" condition as in "count" query
> 
> I think the execution of select count is for garbage collection. 

  Sure

> If count of records that does not exists is executed, will be the garbage 
> collection executed for the deleted records?

  Exactly. No need to count not deleted records :)

Regards,
Vlad
  • [firebird... kragh.tho...@yahoo.com [firebird-support]
    • Re: ... Svein Erling Tysvær setys...@gmail.com [firebird-support]
      • ... kragh.tho...@yahoo.com [firebird-support]
        • ... kragh.tho...@yahoo.com [firebird-support]
    • Re: ... 'paul.mercea-almexa.ro' paul.mer...@almexa.ro [firebird-support]
    • [fir... hv...@users.sourceforge.net [firebird-support]
      • ... Jesus Garcia jeg...@gmail.com [firebird-support]
        • ... hv...@users.sourceforge.net [firebird-support]
          • ... kragh.tho...@yahoo.com [firebird-support]
            • ... hv...@users.sourceforge.net [firebird-support]
              • ... kragh.tho...@yahoo.com [firebird-support]
                • ... ma_go...@yahoo.com [firebird-support]
                • ... kragh.tho...@yahoo.com [firebird-support]
                • ... ma_go...@yahoo.com [firebird-support]
                • ... kragh.tho...@yahoo.com [firebird-support]
                • ... ma_go...@yahoo.com [firebird-support]
                • ... kragh.tho...@yahoo.com [firebird-support]
                • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]

Reply via email to