Jump to content

miab

Members
  • Content Count

    51
  • Joined

  • Last visited

Community Reputation

18 Good

Technical Information

  • Delphi-Version
    Delphi 10.3 Rio

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. miab

    DBcheckbox

    Maybe they use CheckBox-es?
  2. miab

    How make benchmark?

    There is such a test in mORMot 1.18: mormot\SQLite3\Samples\15 - External DB performance\PerfTest.dpr Here, for example, my results(ZEOS 8 svn7805): Running tests using Synopse mORMot framework 1.18.6382, compiled with Delphi 11 Alexandria 32 bit, against SQLite 3.38.2, at 2022-04-28 19:45:52. Insertion speed Direct Batch Trans Batch Trans SQLite3 (file full) 78 4947 47798 97382 SQLite3 (file off) 895 46449 56970 150902 SQLite3 (file off exc) 16290 152360 57546 180786 SQLite3 (mem) 46426 188964 58552 189897 ZEOS SQlite3 80 2271 48028 98382 ZEOS SQlite3 (ext full) 83 2309 46029 103982 ZEOS SQlite3 (ext off) 907 23439 55455 155424 ZEOS SQlite3 (ext off exc) 21101 135648 54687 161046 ZEOS SQlite3 (mem) 31066 156030 55969 163446 FireDAC SQlite3 11458 11450 35217 119967 UniDAC SQlite3 9192 21152 16356 41129 ODBC MSSQL2012 1551 14856 2457 18412 UniDAC MSSQL2012 1758 3637 2380 3724 ZEOS ODBC_W MSSQL2012 1937 6672 2622 40239 ZEOS ODBC_A MSSQL2012 1806 6215 2867 39693 ZEOS OleDB MSSQL2012 1971 6465 2607 51485 ZEOS Firebird 6119 50985 23009 50362 FireDAC Firebird 2796 51112 18134 51333 Oracle 956 55314 2433 82876 ZEOS Oracle 1540 60240 2852 70724 UniDAC Oracle 1084 2462 2026 2573 ZEOS PostgreSQL 1376 61229 3542 64189 FireDAC PostgreSQL 1234 18920 3415 20241 UniDAC PostgreSQL 1057 13510 1846 14945 ZEOS MySQL 2541 39168 2668 42597 FireDAC MySQL 1321 19768 1302 18890 UniDAC MySQL 2267 19860 2563 20004 Read speed By one All Virtual All Direct SQLite3 (file full) 13286 400256 405383 SQLite3 (file off) 13083 381039 379737 SQLite3 (file off exc) 61208 383965 385297 SQLite3 (mem) 58449 389833 390289 ZEOS SQlite3 12813 218455 378845 ZEOS SQlite3 (ext full) 12501 216562 382614 ZEOS SQlite3 (ext off) 12124 206338 369248 ZEOS SQlite3 (ext off exc) 52040 211729 367484 ZEOS SQlite3 (mem) 51253 208707 370096 FireDAC SQlite3 5933 92874 126179 UniDAC SQlite3 6238 96185 136436 ODBC MSSQL2012 2497 113260 194348 UniDAC MSSQL2012 1872 133081 218722 ZEOS ODBC_W MSSQL2012 1344 159555 245712 ZEOS ODBC_A MSSQL2012 1303 141671 218856 ZEOS OleDB MSSQL2012 2497 186101 259040 ZEOS Firebird 23491 88052 126103 FireDAC Firebird 1860 62346 76218 Oracle 3111 56657 173798 ZEOS Oracle 3450 111358 156956 UniDAC Oracle 1096 51343 57296 ZEOS PostgreSQL 2801 141920 198412 FireDAC PostgreSQL 744 44931 47096 UniDAC PostgreSQL 401 90255 128710 ZEOS MySQL 2571 151860 237034 FireDAC MySQL 1063 69310 77087 UniDAC MySQL 1841 110270 158002 Michał
  3. miab

    TDataSet emulation without database

    Why don't you use?: -kbmmemtable -clientdataset -fdmemtable -zmemtable Michał
  4. miab

    New bug with patch 1 for 11.1

    Interestingly, despite the change system.pas, system.dcu has not been updated.
  5. It happened to me recently too. I repeated until success.
  6. miab

    Zeos 7.3 entered the beta phase.

    Cosmetic fixes in ZEOS8 svn7772 https://zeoslib.sourceforge.io/viewtopic.php?f=50&t=73319&p=188585#p188585 Here are links to patches for the older and developed version of ZEOS: https://zeoslib.sourceforge.io/viewtopic.php?f=3&t=143817 Link to the Zeos forum: https://zeoslib.sourceforge.io/ Michał
  7. miab

    64 bit PostgreSQL and Embarcadero ???

    You should install 32 and 64 bit PostgreSQL clients and ensure their exclusive visibility in both modes or explicitly point to the client libraries entry before the connection.
  8. svn://svn.overbyte.be/ics
  9. miab

    Zeos 7.3 entered the beta phase.

    ZEOS 8.0.0 /trunk svn 7717 Works with: Delphi 7-Delphi 11 Alexandria, Lazarus 2.0.8-2.2.0RC2 NEW: ZMemTable - LoadFromStream/SaveToStream https://zeoslib.sourceforge.io/viewtopic.php?f=50&t=73319&p=183311#p183311 https://sourceforge.net/projects/zeoslib/ https://github.com/marsupilami79/zeoslib To be able to use ZMemTable SaveToStream and LoadFrom Stream, you should enable in the zeos.inc file: {$DEFINE ZMEMTABLE_ENABLE_STREAM_EXPORT_IMPORT} // line 97 Michał
  10. miab

    KSVC gone missing.

    From the level of Delphi11 I can see: All 214 and on https://getitnow.embarcadero.com/ All 223
  11. miab

    FMX in VCL app - working natively ?

    Indeed uses // FMX.Forms, Vcl.Forms, ... compiles in D11 too
  12. miab

    FMX in VCL app - working natively ?

    As far as I know you could always mix VCL with FMX only FMX.Forms has to come before VCL.Forms: uses FMX.Forms, Vcl.Forms, ...
  13. miab

    Zeos 7.3 entered the beta phase.

    ZEOS 8.0.0 /trunk svn 7671 Update for D11 Alexandria https://zeoslib.sourceforge.io/viewtopic.php?f=50&p=179881#p179881 https://sourceforge.net/p/zeoslib/code-0/HEAD/tree/trunk/ https://github.com/marsupilami79/zeoslib? Feel free to download, testing, use, submit comments. Michał
  14. miab

    Zeos 7.3 entered the beta phase.

    ZEOS 8.0.0 /trunk svn 7460 NEW: Add ZEventListener component https://zeoslib.sourceforge.io/viewtopic.php?f=50&p=170976#p170976 https://sourceforge.net/projects/zeoslib/ https://github.com/marsupilami79/zeoslib Feel free to download, testing, use, submit comments. Michał
×