[Firebird-devel] [FB-Tracker] Created: (CORE-5909) Index only operations
Index only operations - Key: CORE-5909 URL: http://tracker.firebirdsql.org/browse/CORE-5909 Project: Firebird Core Issue Type: New Feature Components: Engine Reporter: Karol Bieniaszewski Will be good to see index only operations in situation like this: table with index on SOURCE_ID and the query SELECT GS.SOURCE_ID, COUNT(*) FROM GAIA_SOURCE GS GROUP BY GS.SOURCE_ID HAVING COUNT(*)>1 should go throught index only without visiting table data pages it is important when working with big databases e.g. index size can be relatively small compared to table itself. In my real database index have only 18GB but table have 720GB. As you can see accessing only 18GB is not the problem - but accessing 720GB is. same in other places join between tables (using indexed fields) without returning any other field values from some joined tables. I suppose this is big change and require REAL TRANSACTIONAL INDEXES. Current indexes benefit only for intensive updating application. -- 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 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5908) Enhance dynamic libraries loading related error messages
Enhance dynamic libraries loading related error messages Key: CORE-5908 URL: http://tracker.firebirdsql.org/browse/CORE-5908 Project: Firebird Core Issue Type: Improvement Affects Versions: 3.0.3, 2.5.8, 4.0 Alpha 1 Reporter: Alexander Peshkov Due to wrong initial design of class ModuleLoader errors displayed when loading library fails miss OS-specific information about a reason of a failure (no such file, invalid format, unresolved external reference, etc.), they only say - module/library not loaded. This makes fixing related bugs extremely problematic in many cases. Errors reported should be extended in order to show exact reason of a failure. -- 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 -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel