Count command too slow ---------------------- Key: CORE-3666 URL: http://tracker.firebirdsql.org/browse/CORE-3666 Project: Firebird Core Issue Type: Bug Environment: Win2003 r2 sp2, firebird 2.5.1,cpu Xeon E5620 * 4 ,ram 4G Reporter: dudu Priority: Critical
select count(*) from Tablename; result 1585294 4779559 fetches, 0 marks, 804283 reads, 0 writes. 0 inserts, 0 updates, 0 deletes, 0 index, 1585294 seq. Delta memory: 7168 bytes. Total execution time: 0:01:21 (hh:mm:ss) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel