svn commit: r400587 - head/databases/cego
Kurt Jaeger
pi at FreeBSD.org
Sat Oct 31 21:27:36 UTC 2015
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 at 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
More information about the svn-ports-head
mailing list