Date: Sat, 31 Oct 2015 21:27:35 +0000 (UTC) From: Kurt Jaeger <pi@FreeBSD.org> To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r400587 - head/databases/cego Message-ID: <201510312127.t9VLRZvt013523@repo.freebsd.org>
next in thread | raw e-mail | index | archive | help
Author: pi Date: Sat Oct 31 21:27:34 2015 New Revision: 400587 URL: https://svnweb.freebsd.org/changeset/ports/400587 Log: databases/cego: 2.26.2 -> 2.26.7 - Improvements for query execution plan retrieval - Fix in CegoOutput for multline format ( e.g. execution plans have been cut off ) - Performance patch in CegoTableCursor::setup. The getObjectListByTable method was called every time, when the attribute condition has been changed. Since this operation is pretty expensive, it was useful to cache the retrieved index/btree objet in a local class variables. This change results in significant query speedup for joins, where the table cursor has to be setup very often - Small fix in CegoAction::readChain, treating backslashes for quoteEscapeFlag=false was commented, reactivated - Small fix in CegoMain, default for csmode changed to value "ID" - Fix for CegoBtreeManager::insertBTree. Duplicate handling did not work correctly, if CegoBTreeNode::addValue returns false ( node is full ) with a duplicate detection, we also have throw exception. Otherwise the node is split and a duplicate is added. - Performance improvement for nested queries ( exists select, in select). The tablecursor for the select statement is not released and reallocated for subsequent queries ( in CegoQueryHelper, the select handle is reset with argument false ) This has required a different locking strategy for the cursor object in CegoDistCursor. The cursor object has explicit to get in use, if the nextTuple method is called the first time. - Added online help for query cache and table cache in cgadm - Added further performance fix for aggregation queries in CegoExpr and CegoQueryHelper. The aggregation list for CegoExpr now is stored in a class variable and is just evaluated the first time, it is retrieved. In the method CegoQueryHelper::aggregateTuple, the increment calculation of the count aggregation has been changed from memcpy calls to direkt pointer arithmetic - Performance fix has been done for record locking. In many cases, row locking could be avoided, since an appropriate locking is ensured on data page or object level. This brings another significant performance improvement. Submitted by: Bjoern Lemke <lemke@lemke-it.com> Modified: head/databases/cego/Makefile head/databases/cego/distinfo Modified: head/databases/cego/Makefile ============================================================================== --- head/databases/cego/Makefile Sat Oct 31 21:01:17 2015 (r400586) +++ head/databases/cego/Makefile Sat Oct 31 21:27:34 2015 (r400587) @@ -1,7 +1,7 @@ # $FreeBSD$ PORTNAME= cego -PORTVERSION= 2.26.2 +PORTVERSION= 2.26.7 CATEGORIES= databases MASTER_SITES= http://www.lemke-it.com/ Modified: head/databases/cego/distinfo ============================================================================== --- head/databases/cego/distinfo Sat Oct 31 21:01:17 2015 (r400586) +++ head/databases/cego/distinfo Sat Oct 31 21:27:34 2015 (r400587) @@ -1,2 +1,2 @@ -SHA256 (cego-2.26.2.tar.gz) = 48ae5c0c9a38ee825ab8a24d6f951e5a4ae83dfbc618e8e7c32f6fbda29252d5 -SIZE (cego-2.26.2.tar.gz) = 1226359 +SHA256 (cego-2.26.7.tar.gz) = 9843a5f00cdc0b806a1e2fc65b8124b36b88d6a2a9cdb3fcc405603d5dcf272b +SIZE (cego-2.26.7.tar.gz) = 1226686
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201510312127.t9VLRZvt013523>