Harbour DB speed tests comparison

hbDBSpeedTests

Harbour DB speed tests comparison - Registers Count: 821051

MySql configuration( 1 or 2 )

  1. /data/mysql/dbstru.zip - Import structure of Database and then with /tests/mysql_wdo/importDbf.prg transfer all dbf data to mysql
  2. /data/mysql/db.zip - Import all database file to mysql

Dbf configuration

  1. unpack /data/dbf/db.zip to any folder. Do not forget to set that folder in .prg tests!!

LetoDB configuration

  1. unpack /data/dbf/db.zip to any folder(Set Datapath - See step 2).
  2. /data/letodb.ini <- Set the "Datapath" with your full path to dbf folder. FIRST OF ALL!!!!
  3. /data/letodb.exe install <- Install letodb Service
  4. /data/letodb.exe start <- Start letodb Service(Check Windows Services if started)

/data/letodb.exe stop <- Stop letodb Service /data/letodb.exe uninstall <- Uninstall letodb Service

Server specifications

LOCALHOST TEST( in milliseconds )

Connection time to db

DBF LetoDB Mysql(WDO) Mysql(HDO)
0 3 17 2

Test1 - Simple record count with one search criteria - Result: 594060 regs

DBF LetoDB Mysql(WDO) Mysql(HDO)
219 467 152 172

Test2 - Search and retrieve data(sorted by KAR_NUMERO) that match a criteria by date - Result: 39354 regs

DBF LetoDB Mysql(WDO) Mysql(HDO)
534 833 402 232

Test3 - Search and retrieve a specific and unique data in the db - Result: 1reg

DBF LetoDB Mysql(WDO) Mysql(HDO)
301 705 153 154

ImportDbf(DBF->mySql) - import DBF file with 821051 regs

Mysql(WDO) Mysql(HDO)
109146 82928

LAN( gigabit ) TEST( in milliseconds )

Connection time to db

DBF(SMBv2) LetoDB Mysql(WDO) Mysql(HDO)
5 3 24 12

Test1 - Simple record count with one search criteria - Result: 594060 regs

DBF(SMBv2) LetoDB Mysql(WDO) Mysql(HDO)
181 527 213 201

Test2 - Search and retrieve data(sorted by KAR_NUMERO) that match a criteria by date - Result: 39354 regs

DBF(SMBv2) LetoDB Mysql(WDO) Mysql(HDO)
415 2464 476 439

Test3 - Search and retrieve a specific and unique data in the db - Result: 1reg

DBF(SMBv2) LetoDB Mysql(WDO) Mysql(HDO)
264 817 213 193

ImportDbf_lan(DBF->mySql) - import DBF file(in Client) with 821051 regs

Mysql(WDO) Mysql(HDO)
51893 20548
Owner
DIEGO H FAZIO
Donations paypal.me/DiegoHernanFazio
DIEGO H FAZIO
Similar Resources

Web to Desktop framework comparison

Web to Desktop framework comparison This repository was made to create an objective comparison of multiple framework that grant us to "transform" our

Jun 20, 2022

Fft-benchmark - A benchmark for comparison of FFT algorithms performance

FFT benchmark A benchmark for comparison of FFT algorithms performance. Currently supports Intel IPP, KFR, FFTW and KissFFT. Requires: Clang 6.0+ (GCC

Apr 7, 2022

High dynamic range (HDR) image comparison tool for graphics people. With an emphasis on OpenEXR images.

High dynamic range (HDR) image comparison tool for graphics people. With an emphasis on OpenEXR images.

tev — The EXR Viewer A high dynamic range (HDR) image comparison tool for graphics people. tev allows viewing images through various tonemapping opera

Jun 21, 2022

This is example for coding with Kotlin/Native, linking C libraries and comparison java.net.* with libcurl

KotlinNativeExample This is example for coding with Kotlin/Native, linking C libraries and comparison java.net.* with libcurl Running Running mingw64

Jan 22, 2022

A modern, C++-native, header-only, test framework for unit-tests, TDD and BDD - using C++11, C++14, C++17 and later (or C++03 on the Catch1.x branch)

A modern, C++-native, header-only, test framework for unit-tests, TDD and BDD - using C++11, C++14, C++17 and later (or C++03 on the Catch1.x branch)

Catch2 v3 is being developed! You are on the devel branch, where the next major version, v3, of Catch2 is being developed. As it is a significant rewo

Jun 20, 2022

A modern, C++-native, header-only, test framework for unit-tests, TDD and BDD - using C++11, C++14, C++17 and later (or C++03 on the Catch1.x branch)

A modern, C++-native, header-only, test framework for unit-tests, TDD and BDD - using C++11, C++14, C++17 and later (or C++03 on the Catch1.x branch)

Catch2 v3 is being developed! You are on the devel branch, where the next major version, v3, of Catch2 is being developed. As it is a significant rewo

Jun 14, 2022

Write tests in C

NAME libtap - Write tests in C SYNOPSIS #include tap.h int main () { plan(5); int bronze = 1, silver = 2, gold = 3; ok(bronze silver,

Jun 10, 2022

Execute Input/Output tests on a software

Execute Input/Output tests on a software

IO-Tester The goal of this software is to take files as parameter that contains lists of inputs and expected ouputs and to tell the user if the tests

Jun 13, 2022

A modern, C++-native, header-only, test framework for unit-tests, TDD and BDD - using C++11, C++14, C++17 and later (or C++03 on the Catch1.x branch)

A modern, C++-native, header-only, test framework for unit-tests, TDD and BDD - using C++11, C++14, C++17 and later (or C++03 on the Catch1.x branch)

Catch2 v3 is being developed! You are on the devel branch, where the next major version, v3, of Catch2 is being developed. As it is a significant rewo

Jun 23, 2022

Simple useful interoperability tests for WebRTC libraries. If you are a WebRTC library developer we'd love to include you!

Simple useful interoperability tests for WebRTC libraries. If you are a WebRTC library developer we'd love to include you!

Overview This project aims to be a convenient location for WebRTC library developers to perform interoperability tests. Who can Participate The projec

May 22, 2022

Palanteer is a set of high performance visual profiler, debugger, tests enabler for C++ and Python

Palanteer is a set of high performance visual profiler, debugger, tests enabler  for C++ and Python

Palanteer is a set of lean and efficient tools to improve the general software quality, for C++ and Python programs.

Jun 23, 2022

Driver layer GPU libraries and tests for PSP2

PVR_PSP2 Driver layer GPU libraries and tests for PSP2 Currently this project include: Common and PSP2-specific GPU driver headers. Extension library

May 31, 2022

A modern, C++11-native, single-file header-only, tiny framework for unit-tests, TDD and BDD (includes C++98 variant)

lest – lest errors escape testing This tiny C++11 test framework is based on ideas and examples by Kevlin Henney [1,2] and on ideas found in the CATCH

Jun 15, 2022

This repository aims to contain solutions and explanations to various competitive programming problems, which may be important for interviews and online tests of different companies.

This repository aims to contain solutions and explanations to various competitive programming problems, which may be important for interviews and online tests of different companies.

Competitive Programming Solutions Compilation Hello everyone 👋 This repository contains solutions and explanations to various competitive programming

Jun 18, 2022

Community-gathered tests for C++ course read in YSDA

Community-gathered tests for C++ course read in YSDA

YSDA-CPP-collective-tests Коллективно собранные тесты для задач с закрытыми тестами из курса C++. Структура Структура этого репозитория соответствует

Nov 1, 2021

Tests to check the determinism of the basic floating point arithmetic operations on different devices, using Unity and Rust.

Tests to check the determinism of the basic floating point arithmetic operations on different devices, using Unity and Rust.

This repo contains tests to check the determinism (consistency) of the basic floating point arithmetic operations (add, subtract, multiply, divide) on

Dec 24, 2021

Tests and validation for the Hive Helsinki GET_Next_Line project.

gnl-eval Tests and validation for the Hive Helsinki GET_Next_Line project. This is not meant to completely replace careful evaluation, but to give som

May 12, 2022

CSE-7th-Semester-IIT-KGP - Tests, programming assignments and their solution for some courses offered by Department of Computer Science and Engineering, IIT Kharagpur

CSE-7th-Semester-IIT-KGP Disclaimer: Do not copy codes though. Heavy penalization for plagiarism. Programming assignments and their solution for some

Dec 30, 2021
Comments
  • Test 2

    Test 2

    I think that the mysql test 2 is doing a string comparison vs a date comparison, which probably slows down the test. The DBF and LETO use harbour dates which are really stored as integers, which should be far faster than strings.

    Can you retry with a date type in mysql? SELECT {d'2015-09-20'} https://stackoverflow.com/questions/33228765/how-do-i-specify-date-literal-when-writing-sql-query-from-sql-server-that-is-lin/33230070

A modern, C++11-native, single-file header-only, tiny framework for unit-tests, TDD and BDD (includes C++98 variant)

lest – lest errors escape testing This tiny C++11 test framework is based on ideas and examples by Kevlin Henney [1,2] and on ideas found in the CATCH

Jun 15, 2022
C unit tests with a small header-only library.
C unit tests with a small header-only library.

C unit tests Minimalistic unit tests in C. Uses the __attribute__((constructor)) which, as far as I know, is supported by GCC and clang. So this proba

May 10, 2022
By putting in a lot of speed, the speed sequence is sorted and divided, three types of speed interval distribution maps are generated.(including broken line graph,histogram and curve graph)

Auto-drawing-speed-range-map By putting in a lot of speed, the speed sequence is sorted and divided, three types of speed interval distribution maps a

May 14, 2022
hb-xlib bindings for Harbour language.

hb-xlib hb-xlib is a Harbour module providing bindings for the Xlib graphics library. This project is intended for people who want to start to program

Feb 6, 2022
Speed Running and Competition Doom. For strictly vanilla speed runs and competitions - forked from CNDoom

Speed Running and Competition Doom Speed Running and Competition Doom is based on Chocolate Doom and aims to accurately reproduce the original DOS ver

May 24, 2022
A stable adaptive partitioning comparison sort.
A stable adaptive partitioning comparison sort.

Intro This document describes a partitioning stable adaptive comparison-based sort named gridsort. Binary Cube Gridsort sorts data by storing data in

Jun 17, 2022
Fast comparison-based sort algorithm

nanosort Algorithm nanosort aims to be a fast comparison-based sorting algorithm, tuned for POD types of reasonably small sizes. nanosort implements a

May 24, 2022
A stable adaptive branchless partitioning comparison sort.
A stable adaptive branchless partitioning comparison sort.

Intro This document describes a partitioning stable adaptive comparison-based sort named fluxsort. Benchmarks and a visualization are available at the

May 22, 2022
A software serial driver package by using the hardware timer capture / comparison functionality.

Soft serial 1.简介 Soft serial 是利用硬件定时器捕获/比较功能实现软件模拟串口的软件包。 1.1目录结构 Soft serial 软件包目录结构如下所示: soft_serial ├───inc // 头文件目录 │

Oct 2, 2021
C implementation of C++ Utility functions Integer Comparison Macros

C implementation of C++ Utility functions Integer Comparison Macros

May 27, 2022