Recent

Author Topic: Offical ZeoLib 7.2-Beta has been released  (Read 11656 times)

EgonHugeist

  • Jr. Member
  • **
  • Posts: 78
Offical ZeoLib 7.2-Beta has been released
« on: October 22, 2014, 09:04:01 am »
Hi there,

we finally did release the first 7.2 Beta version.
You can download the zip here: http://sourceforge.net/projects/zeoslib/files/Zeos%20Database%20Objects/zeosdbo-7.2.0-beta/

I was able to increase the performance in a high rate(even if not top of data is reached) without changing the current structures.
 
Enjoy! OpenSource rocks!
Cheers, Michael

silvestre

  • Jr. Member
  • **
  • Posts: 76
Re: Offical ZeoLib 7.2-Beta has been released
« Reply #1 on: October 22, 2014, 10:15:57 am »
@EgonHugeist

 Thank you very much!

 I followed the updates and there are lots of performance improvements.  :)

patyi

  • Full Member
  • ***
  • Posts: 168
Re: Offical ZeoLib 7.2-Beta has been released
« Reply #2 on: October 22, 2014, 09:28:28 pm »
Thank you Zeos team !

Zeos is the best and most stable database component package for Lazarus !
I have use Zeos 7.2 since a year in my Linux and Windows projects with MySQL and Firebird SQL engines with success !

Best regards, Patyi.

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: Offical ZeoLib 7.2-Beta has been released
« Reply #3 on: October 23, 2014, 09:01:39 am »
Congratulations & thanks, Michael!
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

JD

  • Hero Member
  • *****
  • Posts: 1848
Re: Offical ZeoLib 7.2-Beta has been released
« Reply #4 on: October 23, 2014, 10:24:04 am »
Ah! It's update time again.  :D A million thanks to you, Michael & the rest of the team for all your hard work. Zeos is one of the first components I add to Lazarus because it makes my work easy.

JD
Windows - Lazarus 2.1/FPC 3.2 (built using fpcupdeluxe),
Linux Mint - Lazarus 2.1/FPC 3.2 (built using fpcupdeluxe)

mORMot; Zeos 8; SQLite, PostgreSQL & MariaDB; VirtualTreeView

jma_sp

  • Full Member
  • ***
  • Posts: 150
  • El conocimiento si ocupa lugar.
Re: Offical ZeoLib 7.2-Beta has been released
« Reply #5 on: October 23, 2014, 10:51:55 am »
Thankyou very much!!!!

There is somewhere a link to changelog?

Regards.
Devuan Beowulf 3.0( JWM/ROX/iDesk) - Puppy Linux,  Haiku OS,.ReactOS 0.4.xx  - FreeDos .

EgonHugeist

  • Jr. Member
  • **
  • Posts: 78
Re: Offical ZeoLib 7.2-Beta has been released
« Reply #6 on: October 23, 2014, 12:19:55 pm »
Thank you guys, for the feedback  ;D

Accordinly a changlog ... simply check the commits: http://sourceforge.net/p/zeoslib/code-0/commit_browser
There you got a large list of changes we made. Some small bug-fixes are done, but most of them are related to performance up's.

Loads of code is prepared for comming TZFields(e.G. Byte, Word, UInt64 fields, ArrayFields and first approches for TDataSet-Fields) but this will go to 7.3, i think.
The Zeos internals are prepared for BATCH-ArrayBindings e.G. Mass-Data-Manimulations. This features are not available in Compenent-Layer yet, since we need new TParam/TField descandants -> 7.3 too. I had not the time to complete everything and the users asking for a stable candidate  :'(. So stay tuned...

A little performance reference of 7.2: http://synopse.info/forum/viewtopic.php?id=1508&p=3
compared to 7.1: http://blog.synopse.info/post/2013/11/04/Updated-mORMot-database-benchmark-including-MS-SQL

As you can see the performance boost really is impressive. Note, these tests are done with ZDBC (including array bindings), NOT with the TComponent-Layer and all benchmarks are done against the Synopse ColumnsToJSON tests. To be clear: We'll never win the race against Synopse(optimized ColumnsToJSON proc for the framework) it's selves but we are somewhat faster than FireDac, UniDac or ODBC Access.  :P

We also got first feedback in numbers here: http://www.lazarusforum.de/viewtopic.php?f=17&t=8183
User MMVisual did compare 7.1 vs. 7.2 SQLite behavior with his application. The testet code performance twice faster now.

Feel free to Attach some personal comparisions!

Michael
« Last Edit: October 23, 2014, 12:39:51 pm by EgonHugeist »

mangakissa

  • Hero Member
  • *****
  • Posts: 1131
Re: Offical ZeoLib 7.2-Beta has been released
« Reply #7 on: October 23, 2014, 02:31:50 pm »
Quote
....but we are somewhat faster than FireDac....
Based on what? FireDAC is working native, ZOEOS not.
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

EgonHugeist

  • Jr. Member
  • **
  • Posts: 78
Re: Offical ZeoLib 7.2-Beta has been released
« Reply #8 on: October 23, 2014, 02:48:24 pm »
Quote
....but we are somewhat faster than FireDac....
Based on what? FireDAC is working native, ZOEOS not.
Based on test i linked before. Just study the Links.. What do you mean with "working native"? IMO(can't compare it, i have NO FireDac) uses Zeos same native LIBRARY access as FireDac is doing that or did they write a own protocol library collection like UniDac did it for some providers(e.g libmysql.dll replacement)?

Edit:

Note i didn't want to say Zeos is the fastest DB-Access-Component(NEVER DID COMPARE OTHER COMPONENTS). As i wrote before the Synopse tests aren't made with our TZDataSet-descendants! These tests are made with our internal DBC(Database-Connection)-Layer. Our TZDataSet-Descendants do access DBC directly. For me it was more interesting to compare the performance of older Zeos releases with current 7.2-approach. So the Synopse tests have been a good indicatore for some problems i've resolved inbetween..

But i also did some Perfomance comparisions with our TZDataSet-Descendants with our test-suites and the current performance boost is amazing. In dependency of column-types and providers our 7.2-Query component are twice to 20 times faster than 7.1 based on OUR Zeos-Performance test. Also updating and sorting is loads faster now.
« Last Edit: October 23, 2014, 03:22:10 pm by EgonHugeist »

miab3

  • Full Member
  • ***
  • Posts: 145
Re: Offical ZeoLib 7.2-Beta has been released
« Reply #9 on: October 23, 2014, 03:18:23 pm »
@mangakissa

Based on what? FireDAC is working native, ZOEOS not.

What does it mean native.
From what I know FirDAC uses exactly the same client libraries which ZEOS.
With some exceptions:  :D
e.g. ZEOS http://sourceforge.net/p/zeoslib/code-0/3426/tree//branches/testing-7.2/src/plain/ZPlainMySqlDriver.pas?diff=500986a671b75b2b8b001f0f:3425
FireDAC https://forums.embarcadero.com/thread.jspa?threadID=109139&tstart=15

Michal

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: Offical ZeoLib 7.2-Beta has been released
« Reply #10 on: October 23, 2014, 03:24:54 pm »
What does it mean native.
Presumably he means accessing the remote database using native Object Pascal code sending data over the wire instead of calling the database driver API to interact.

Of course, the database driver is very likely to be native machine code as well (as opposed to just in time Java or .Net code).

I agree the term "native" is a bit misleading here...
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

marcov

  • Administrator
  • Hero Member
  • *
  • Posts: 11383
  • FPC developer.
Re: Offical ZeoLib 7.2-Beta has been released
« Reply #11 on: October 23, 2014, 03:53:05 pm »
What does it mean native.
Presumably he means accessing the remote database using native Object Pascal code sending data over the wire instead of calling the database driver API to interact.

I checked, and that doesn't seem to be the case. At least in the postgresql/enterprisedb OR mysql case:

http://docwiki.embarcadero.com/RADStudio/XE6/en/Connect_to_PostgreSQL_%28FireDAC%29

http://docwiki.embarcadero.com/RADStudio/XE5/en/Connect_to_MySQL_Server_%28FireDAC%29

MSSQL seems to suggest ODBC, but maybe that is just unclear documentation:
http://docwiki.embarcadero.com/RADStudio/XE6/en/Connect_to_Microsoft_SQL_Server_%28FireDAC%29

mangakissa

  • Hero Member
  • *****
  • Posts: 1131
Re: Offical ZeoLib 7.2-Beta has been released
« Reply #12 on: October 24, 2014, 09:41:00 am »
Exactly what marcov says. FireDAC has own drivers built in his package to connect a database without a client library.
Look at the image on this page. I'm very fond of native connection, because you don't care about deploying the right client driver.

Is your comparison to fireDAC with client libraries, it's nice to hear.
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

marcov

  • Administrator
  • Hero Member
  • *
  • Posts: 11383
  • FPC developer.
Re: Offical ZeoLib 7.2-Beta has been released
« Reply #13 on: October 24, 2014, 09:51:17 am »
Exactly what marcov says. FireDAC has own drivers built in his package to connect a database without a client library.

(I was saying that it seemed that FireDAC did not do wire protocol by default)

Quote
Look at the image on this page. I'm very fond of native connection, because you don't care about deploying the right client driver.

I think native on that page means "through the client lib" and is meant as contrast to using ODBC or ADO for everything.

So there is no difference between FireDac and Zeos on that score, except that using FPC, Zeos uses FreeTDS instead of oledb directly. I don't know the impact of that (other than the additional DLL) though.
 

mangakissa

  • Hero Member
  • *****
  • Posts: 1131
Re: Offical ZeoLib 7.2-Beta has been released
« Reply #14 on: October 24, 2014, 10:51:06 am »
I'm using MyDAC (Devart) components which are native connected to the database. AFAIK FireDAC does the same but also have the opportunity to use client libraries.
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

 

TinyPortal © 2005-2018