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