aboutsummaryrefslogtreecommitdiffstats
path: root/databases
diff options
context:
space:
mode:
authorpi <pi@FreeBSD.org>2017-01-01 02:14:09 +0800
committerpi <pi@FreeBSD.org>2017-01-01 02:14:09 +0800
commit7f88852be5bb3e25317e9ece9a4be9f67922f4c3 (patch)
tree6426ef45e0b93999b900c3370f1bf252665986c6 /databases
parent74a99a4cb97564de5160c5c13d6b227330c44a7f (diff)
downloadfreebsd-ports-gnome-7f88852be5bb3e25317e9ece9a4be9f67922f4c3.tar.gz
freebsd-ports-gnome-7f88852be5bb3e25317e9ece9a4be9f67922f4c3.tar.zst
freebsd-ports-gnome-7f88852be5bb3e25317e9ece9a4be9f67922f4c3.zip
databases/cego: update 2.32.3 -> 2.32.4
- Fixes and improvements for table export added In CegoXPorter::xmlExportable, the pOutStream pointer was deleted, which lead to a core dump ( pointer is already deleted by Element ) Row counter handling and messages have been improved - Change back to memove call in CegoBTreeNode:shiftEntries. Copying manually and bytewise decreased performance about two times for building up btree objects. This has been observed on native POSIX ( FreeBSD 11 ) but also on MSYS64 compiles - Improvements for CegoBTreeCursor. With the new introduced methods CegoBTreeNode::getMedPage and CegoBTreeNode::rightValue, the search for the appropriate subnode can be made with logarithmic efforts instead of linear search. To validate this improvement, the following query has been setup for a random filled table t1 select * from t1 ta where exists ( select * from t1 tb where tb.b = ta.b ); Execution time with the improved btree cursor was two times faster than with old implementation. - More performance improvements made for btree creation changed linear search efforts in CegoBTreeNode::getChildPage to logarithmic search efforts ( introduced lb /rb variable ) - Change in CegoBTreeManager::allocPage. Since for cache based creation, just a pageId must be allocated, the low level method CegoFileHandler::allocatePage is used.This avoids an unnessary bufferFix call for the new page - Introduced appendFid variable for CegoFileHandler class. In case of many managed datafiles, the last file with avaiable pages is used for the allocatePage method. - Performance comparison to MariaDB indicates now a better scaling from 2 million rows and up ( by using cego btree cache ) - Improvement modifications for btree implementation increased build up speed for just about 3 percent. It seems, the most time is used by calling shiftEntries method, where memory is moved via memmove. I observed, that 8k page size ( instead of 16k ) brought up some performance improvement for btree creation of about 100% ( for type string(60) with random values ) - More performance improvements in CegoBTreeManager and CegoBTreeNode, overall impact still has to be analysed - Fix in CegoTableManager added for alter table modify column, columns with existing btree or key objects can not be modified anymore - Further improvement approach in CegoBTreeManager to increase btree creation performance. BufferPage handles have been changed from native variables to pointer handles. This should reduce page access efforts in case of enabled btree cache Submitted by: Bjoern Lemke <lemke@lemke-it.com>
Diffstat (limited to 'databases')
-rw-r--r--databases/cego/Makefile2
-rw-r--r--databases/cego/distinfo6
2 files changed, 4 insertions, 4 deletions
diff --git a/databases/cego/Makefile b/databases/cego/Makefile
index 83e5983d6c6b..6551208dd385 100644
--- a/databases/cego/Makefile
+++ b/databases/cego/Makefile
@@ -1,7 +1,7 @@
# $FreeBSD$
PORTNAME= cego
-PORTVERSION= 2.32.3
+PORTVERSION= 2.32.4
CATEGORIES= databases
MASTER_SITES= http://www.lemke-it.com/
diff --git a/databases/cego/distinfo b/databases/cego/distinfo
index c1cf609f2085..82f2b8650972 100644
--- a/databases/cego/distinfo
+++ b/databases/cego/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1482570949
-SHA256 (cego-2.32.3.tar.gz) = a4a5c0800606f18349152e702502c766db278b5aa61703f7a7fd474ef55e13cd
-SIZE (cego-2.32.3.tar.gz) = 1449191
+TIMESTAMP = 1483134754
+SHA256 (cego-2.32.4.tar.gz) = 8b5ebc092c758dd01891c0d1f8d6a3046780176ae247aa8fec92ad44d406a2f1
+SIZE (cego-2.32.4.tar.gz) = 1395960