#1 2015-08-15 10:24:52

miab3
Member
From: Poland
Registered: 2014-10-01
Posts: 188

My test 15 - External DB performance and ZEOS 7.2-beta

Running tests using Synopse mORMot framework 1.18.1790, compiled with Delphi XE2, against SQLite 3.8.11.1, at 2015-08-15 11:32:29.

Insertion speed
 			Direct	Batch	Trans	Batch Trans
SQLite3 (file full)	8	466	23140	32561
ZEOS SQlite3		11	368	22256	26940
AnyDAC SQlite3		16179	27717	35384	101061
UniDAC SQlite3		10	279	13249	13030
ZEOS Firebird		1266	60109	17245	61127
AnyDAC Firebird		18399	52010	18235	50654
Oracle			1004	75597	2442	76109
ZEOS Oracle		1049	61026	2471	47147
AnyDAC Oracle		1038	58230	2495	59366
UniDAC Oracle		971	4653	2127	5042
ZEOS PostgreSQL		503	14248	2420	23939
AnyDAC PostgreSQL	1269	18519	2333	18572
UniDAC PostgreSQL	581	10688	752	14161
ZEOS MySQL		9511	37415	11796	31780
AnyDAC MySQL		7620	31507	10615	45746
UniDAC MySQL		7929	28611	11243	29960

Read speed
 			By one	All Virtual	All Direct
SQLite3 (file full)	84365	509424	502714
ZEOS SQlite3		29463	205035	333400
AnyDAC SQlite3		6781	77592	101590
UniDAC SQlite3		1664	80558	102262
ZEOS Firebird		13315	127913	174228
AnyDAC Firebird		788	65992	83232
Oracle			2470	133418	183972
ZEOS Oracle		2455	120293	155806
AnyDAC Oracle		1933	53568	66895
UniDAC Oracle		1113	42780	47848
ZEOS PostgreSQL		2330	106469	147470
AnyDAC PostgreSQL	576	34965	39092
UniDAC PostgreSQL	330	78092	103727
ZEOS MySQL		10145	175864	276243
AnyDAC MySQL		3863	95100	129951
UniDAC MySQL		5138	129698	195000

ZEOSLIB 7.2-beta svn 3638: http://svn.code.sf.net/p/zeoslib/code-0 … sting-7.2/

Michal

Last edited by miab3 (2015-08-15 10:41:51)

Offline

#2 2015-08-15 11:20:08

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,182
Website

Re: My test 15 - External DB performance and ZEOS 7.2-beta

Thanks for sharing the numbers.
No test with direct SynDBODBC.pas unit? I guess it may be a little lower than ZDBC/Zeos.

It is worth saying that AnyDAC/FireDAC is changing the default SQlite3 configuration to synchoff/exclusive mode.
See http://synopse.info/files/html/Synopse% … ml#TITL_60

Offline

#3 2015-08-15 12:39:50

zed
Member
From: Belarus
Registered: 2015-02-26
Posts: 105

Re: My test 15 - External DB performance and ZEOS 7.2-beta

+1 for tests with ODBC.

Offline

#4 2015-08-15 16:16:36

Junior/RO
Member
Registered: 2011-05-13
Posts: 207

Re: My test 15 - External DB performance and ZEOS 7.2-beta

Lower is better?

Offline

#5 2015-08-16 11:16:49

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,182
Website

Re: My test 15 - External DB performance and ZEOS 7.2-beta

@Junior
No, lower numbers = slower.
I guess that ODBC is slower than Zeos/ZDBC, since ZDBC has direct access to the database driver.

This is what we observed on our side.
See http://synopse.info/files/html/Synopse% … #TITLE_121

Offline

#6 2016-01-12 10:10:24

miab3
Member
From: Poland
Registered: 2014-10-01
Posts: 188

Re: My test 15 - External DB performance and ZEOS 7.2-beta

Running tests using Synopse mORMot framework 1.18.2244, compiled with Delphi 10 Seattle, against SQLite 3.10.0, at 2016-01-12 10:56:55.
Insertion speed

			Direct	Batch	Trans	Batch Trans
SQLite3 (file full)	62	1885	54550	74440
ZEOS SQlite3		92	1778	39365	58060
FireDAC SQlite3		17302	31822	37488	120371
ZEOS Firebird		357	5586	6292	8287
FireDAC Firebird	298	9928	8120	7772
Oracle			809	46830	1592	46620
ZEOS Oracle		884	49108	1865	20496
FireDAC Oracle		667	36402	1728	29090
ZEOS PostgreSQL		342	12341	2379	18120
FireDAC PostgreSQL	914	16701	2450	16653
ZEOS MySQL		2319	30033	2427	23012
FireDAC MySQL		1926	21835	2192	36423

Read speed

			By one	All Virtual	All Direct
SQLite3 (file full)	66394	504286	507872
ZEOS SQlite3		45045	203641	357986
FireDAC SQlite3		5316	96192	130944
ZEOS Firebird		24898	96065	134419
FireDAC Firebird	558	54994	78133
Oracle			2551	126518	187666
ZEOS Oracle		2371	61260	157713
FireDAC Oracle		1739	60749	78895
ZEOS PostgreSQL		2316	81826	149929
FireDAC PostgreSQL	529	35701	44792
ZEOS MySQL		2395	119175	227583
FireDAC MySQL		1415	83693	109955

ZEOS 7.3 svn3730 Delphi 10 Seattle Win32

Michal

Last edited by miab3 (2016-01-12 10:27:25)

Offline

#7 2016-01-12 14:34:33

miab3
Member
From: Poland
Registered: 2014-10-01
Posts: 188

Re: My test 15 - External DB performance and ZEOS 7.2-beta

Add MSSQL-ODBC SQL Server Native Client 11.0 remote

Running tests using Synopse mORMot framework 1.18.2244, compiled with Delphi 10 Seattle, against SQLite 3.10.0, at 2016-01-12 15:23:09.
Insertion speed

			Direct	Batch	Trans	Batch Trans
SQLite3 (file full)	71	2328	55403	128518
ZEOS SQlite3		97	2379	42335	76210
FireDAC SQlite3		18096	32383	39540	123456
ODBC MSSQL2012		1010	12497	2511	21083
ZEOS ODBC_W MSSQL2012	1257	37149	2460	37088
ZEOS ODBC_A MSSQL2012	1141	36157	2526	35155
ZEOS OleDB MSSQL2012	1317	2693	2465	47224
FireDAC MSSQL2012	1138	2452	2492	33653
ZEOS Firebird		471	7891	7209	9511
FireDAC Firebird	275	7471	8719	10213
Oracle			736	63895	2154	63489
ZEOS Oracle		850	48913	2313	48874
FireDAC Oracle		829	33849	2132	46199
ZEOS PostgreSQL		546	13358	2280	19152
FireDAC PostgreSQL	895	16905	2511	16744
ZEOS MySQL		2381	30604	2469	31232
FireDAC MySQL		1888	25834	2011	34124

Read speed

			By one	All Virtual	All Direct
SQLite3 (file full)	87389	516102	520345
ZEOS SQlite3		53766	189559	372079
FireDAC SQlite3		5492	95745	135828
ODBC MSSQL2012		2550	90571	227086
ZEOS ODBC_W MSSQL2012	1269	89937	162665
ZEOS ODBC_A MSSQL2012	1264	93210	158257
ZEOS OleDB MSSQL2012	2424	136709	307144
FireDAC MSSQL2012	1708	101341	163031
ZEOS Firebird		27082	94060	138281
FireDAC Firebird	598	60293	78280
Oracle			2372	107335	190338
ZEOS Oracle		2493	92926	161191
FireDAC Oracle		1516	58598	72710
ZEOS PostgreSQL		2207	82628	148712
FireDAC PostgreSQL	531	34188	45066
ZEOS MySQL		2421	103536	230489
FireDAC MySQL		1386	81234	109863

ZEOS 7.3 svn3730 Delphi 10 Seattle Win32
http://svn.code.sf.net/p/zeoslib/code-0 … sting-7.3/
http://zeoslib.sourceforge.net/viewtopi … 082#p56082

Michal

Last edited by miab3 (2016-01-12 19:59:51)

Offline

#8 2016-01-12 17:12:27

EgonHugeist
Member
From: Germany
Registered: 2013-02-15
Posts: 190

Re: My test 15 - External DB performance and ZEOS 7.2-beta

@All

since Zeos7.3 i made a little code join with/for the synopse-project.
There is a new define $USE_SYNCOMMONS available which than directly uses the SynCommons.TJSONWriter.
You can either add it to your compiler options or just uncommend the define in Zeos.inc.

This define than finally brings actual best performance for ZDBC + mORMot. The SynCommons.TJSONWriter is pretty nice optimized, because of this i decided to skip a Zeos own approch and just used the one of mORMot.  Now Zeos is able to return JSONs. So both projects do benefit from the latest patches.

As you've noticed Michal (miab3) also did test the two new Zeos-ODBC Drivers. I wrote them to make the leap according MSSQL + Zeos and NON Windows plattforms and becouse i wanted to know what brings best MSSQL access rates ... OleDB is the winner in this domain.

Numbers are talking, guys ... from !my! POV there are no performance (are there otheres for mORMot? ) advantages using FireDac or UniDac as well. Remembering the first results of 7.1 series Zeos access rates where between FireDac/UniDac. Now most code is optimized and completely refactored.

Arnaud and me worked hand in hand to get best performance running for his framework and Zeos it's selves too of course!

Note i'm not ready with the complete refactoring. Just most parts of ZCore up to ZDbc have been reworked from ground up. Actually my Zeos coding time is rare comparing my previous activities but 7.2-stable will come soon. (For those who do not trust in the beta attribute ... It's up to Mark,Michal,Jan and me just to tag 7.2 as stable candidate! We'll do that if latest fix is older than 3 weeks.

Missing points:
I've noticed there are adtional options in mORMot. Such like limit the lob sizes or just ignore them.
As a work around i propose to use the JSONWriter.TSQLFieldBits/Fields for composing the json-contents and just ignore those fields. Any other ideas?

@miab3

thanks for attaching the results! I was out of time to setup the whole database batery!

Sadly i see you miss a Zeos OleDB-driver results, or am i wrong? Could you test the OleDB driver + MSSQL too?
In addition could you enable the $USE_SYNCOMMONS define please?

@AB

i was waiting a while before anouncing the define or new drivers. Some final regressions have been fixed. (And beause of lack of time i've tested each protocol @all)
===> THANK's for updating your documantations! This is a great advertinsing for Zeos.


Cheers, Michael

Last edited by EgonHugeist (2016-01-13 06:20:07)

Offline

#9 2016-01-12 20:02:38

miab3
Member
From: Poland
Registered: 2014-10-01
Posts: 188

Re: My test 15 - External DB performance and ZEOS 7.2-beta

@Michael,

I added to the previous ZEOS 7.3 OleDB (at the moment without $USE_SYNCOMMONS)

Michal

Offline

#10 2016-01-13 19:32:57

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,182
Website

Re: My test 15 - External DB performance and ZEOS 7.2-beta

Rebuild the project, erasing first all existing .dcu in path.

Offline

#11 2016-01-13 19:52:06

miab3
Member
From: Poland
Registered: 2014-10-01
Posts: 188

Re: My test 15 - External DB performance and ZEOS 7.2-beta

@ab, @EgonHugeist,


Enable USE_SYNCOMMONS

mORMot: [dcc32 Fatal Error] SynDBZEOS.pas(138): F2051 Unit ZDbcCache was compiled with a different version of SynCommons.TTextWriter.AddNoJSONEscapeUTF8

ZEOS: "ZDbc contains implicit unit(s) SynCommons, SynLZ"

It gets a cross between a libraries.
It's probably not a good solution?

Delphi 10 Seattle Win32; mORMot 1.18.2257; ZEOS 7.3 svn3731

Michal

Last edited by miab3 (2016-01-13 20:17:55)

Offline

#12 2016-01-13 20:16:34

miab3
Member
From: Poland
Registered: 2014-10-01
Posts: 188

Re: My test 15 - External DB performance and ZEOS 7.2-beta

@ab,

TestSQL3.exe:
!  - UTF8: 14,000 / 175,151 FAILED  1.12s

Delphi 10 Seattle Win32 mORMot 1.18.2257

Michal

Offline

#13 2016-01-13 20:30:49

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,182
Website

Re: My test 15 - External DB performance and ZEOS 7.2-beta

On my PC:

   Synopse mORMot Framework Automated tests
  ------------------------------------------

...
  - Ini files: 7,004 assertions passed  20.60ms
  - UTF8: 176,152 assertions passed  516.84ms
  - Iso 8601 date and time: 48,017 assertions passed  5.02ms
...


Using mORMot 1.18.2257 FTS3
Running on Windows 7 64bit SP1 (6.1.7601) with code page 1252
TSQLite3LibraryStatic 3.10.0 with internal MM
Generated with: Delphi 10 Seattle compiler

Time elapsed for all tests: 46.78s
Tests performed at 13/01/2016 21:30:01

Total assertions failed for all test suits:  0 / 23,709,103
! All tests passed successfully.

What is your code page?

Offline

#14 2016-01-13 21:37:55

EgonHugeist
Member
From: Germany
Registered: 2013-02-15
Posts: 190

Re: My test 15 - External DB performance and ZEOS 7.2-beta

Michal is from Poland so it should be CP1251

On my side the code compiles and runs fine with my whole compiler battery. No issues to see, just better performance results (:

Offline

#15 2016-01-13 23:33:20

miab3
Member
From: Poland
Registered: 2014-10-01
Posts: 188

Re: My test 15 - External DB performance and ZEOS 7.2-beta

Enable USE_SYNCOMMONS:

Running tests using Synopse mORMot framework 1.18.2257, compiled with Delphi 10 Seattle, against SQLite 3.10.0, at 2016-01-14 00:28:48.
Insertion speed

 			Direct	Batch	Trans	Batch Trans
SQLite3 (file full)	73	2224	48436	79994
ZEOS SQlite3		109	2313	32849	63760
FireDAC SQlite3		18414	32522	38993	120473
ODBC MSSQL2012		813	8032	2396	21961
ZEOS ODBC_W MSSQL2012	1322	37504	2474	39177
ZEOS ODBC_A MSSQL2012	1089	34769	2428	37281
ZEOS OleDB MSSQL2012	1188	2519	2522	39679
FireDAC MSSQL2012	1232	2346	2408	30788
ZEOS Firebird		446	5392	7636	12505
FireDAC Firebird	265	9980	6602	10609
Oracle			842	57359	1682	47757
ZEOS Oracle		787	48471	2323	50581
FireDAC Oracle		842	49012	2136	46999
ZEOS PostgreSQL		479	10864	2288	19950
FireDAC PostgreSQL	992	16699	1681	16859
ZEOS MySQL		2350	28706	2466	30955
FireDAC MySQL		1969	38152	2068	38869

Read speed

 			By one	All Virtual	All Direct
SQLite3 (file full)	88062	482299	493924
ZEOS SQlite3		57301	196047	450491
FireDAC SQlite3		5493	94957	136032
ODBC MSSQL2012		2524	96694	223015
ZEOS ODBC_W MSSQL2012	1272	97633	174137
ZEOS ODBC_A MSSQL2012	1264	101317	166944
ZEOS OleDB MSSQL2012	2355	125571	372134
FireDAC MSSQL2012	1676	104552	166750
ZEOS Firebird		25949	92407	143135
FireDAC Firebird	643	59191	77674
Oracle			2243	103201	184175
ZEOS Oracle		2467	92033	171697
FireDAC Oracle		1498	58566	75607
ZEOS PostgreSQL		2618	84711	163158
FireDAC PostgreSQL	469	33022	45944
ZEOS MySQL		2448	127349	283575
FireDAC MySQL		1451	80362	111582

ZEOS 7.3 svn3731 Delphi 10 Seattle Win32

Michal

Offline

#16 2016-01-15 14:22:37

miab3
Member
From: Poland
Registered: 2014-10-01
Posts: 188

Re: My test 15 - External DB performance and ZEOS 7.2-beta

Disable USE_SYNCOMMONS:

Running tests using Synopse mORMot framework 1.18.2260, compiled with Delphi 10 Seattle, against SQLite 3.10.0, at 2016-01-15 15:16:47.
Insertion speed

 			Direct	Batch	Trans	Batch Trans
SQLite3 (file full)	68	2165	54346	117774
SQLite3 (file off)	1213	68362	75790	191109
SQLite3 (file off exc)	24027	192108	75024	202971
SQLite3 (mem)		65624	225968	77443	225509
TObjectList (static)	178986	365176	176435	353756
TObjectList (virtual)	169825	343430	170508	341064
SQLite3 (ext full)	83	2944	62902	147110
SQLite3 (ext off)	1301	33429	86846	185542
SQLite3 (ext off exc)	33104	179623	85576	192663
SQLite3 (ext mem)	77218	208255	87423	210190
ZEOS SQlite3		154	4027	43263	68121
FireDAC SQlite3		17998	31924	38710	118962
ODBC MSSQL2012		1115	11842	2371	21344
ZEOS ODBC_W MSSQL2012	1177	31570	2404	36979
ZEOS ODBC_A MSSQL2012	1282	40021	2446	33856
ZEOS OleDB MSSQL2012	1378	3184	2600	42358
FireDAC MSSQL2012	1206	2271	2555	30365
ZEOS Firebird		423	5129	3848	8803
FireDAC Firebird	284	6497	6293	8595
Oracle			677	19427	1624	51729
ZEOS Oracle		528	43027	2006	40446
FireDAC Oracle		801	33016	1737	28510
ZEOS PostgreSQL		505	11355	2221	19175
FireDAC PostgreSQL	1001	15790	1873	16676
ZEOS MySQL		2296	28764	2427	30099
FireDAC MySQL		1612	30686	1873	39025
	
Read speed

 			By one	All Virtual	All Direct
SQLite3 (file full)	91164	506277	523231
SQLite3 (file off)	90778	525430	517812
SQLite3 (file off exc)	91549	531011	515676
SQLite3 (mem)		91426	528932	518134
TObjectList (static)	166588	690035	699300
TObjectList (virtual)	165251	391849	661900
SQLite3 (ext full)	101586	263393	505458
SQLite3 (ext off)	99860	262453	507305
SQLite3 (ext off exc)	101144	258304	506431
SQLite3 (ext mem)	99316	256160	502563
ZEOS SQlite3		52975	202420	348237
FireDAC SQlite3		5385	98767	131669
ODBC MSSQL2012		2391	95995	219211
ZEOS ODBC_W MSSQL2012	1244	102578	164414
ZEOS ODBC_A MSSQL2012	1249	100502	154521
ZEOS OleDB MSSQL2012	2350	159841	309501
FireDAC MSSQL2012	1670	109994	169508
ZEOS Firebird		24432	97578	135725
FireDAC Firebird	444	52564	78346
Oracle			2011	96564	168055
ZEOS Oracle		2380	86110	134890
FireDAC Oracle		1527	57287	71551
ZEOS PostgreSQL		2287	82632	149866
FireDAC PostgreSQL	510	36242	42399
ZEOS MySQL		2555	113247	232536
FireDAC MySQL		1425	79583	110734

ZEOS 7.3 svn3731 Delphi 10 Seattle Win32

Michal

Offline

#17 2017-06-10 03:49:52

houdw2006
Member
Registered: 2015-05-23
Posts: 48

Re: My test 15 - External DB performance and ZEOS 7.2-beta

I just downloaded ZEOS Lib 7.3 from SourceForge, integrated with mORMot and compiles under XE8,  every thing seems OK.  I am trying to connect to MSSQL by chosing the connecting parameters from the Update Connection Setting of SynDBExplorerClasses. What should be specified for the Server input ? I tried the "IP", "IP,1433", and "IP:1433"  as the Server parameter without success. So what should be specified for the Server and Database parameters?

Thanks in advance.

Last edited by houdw2006 (2017-06-10 08:12:32)

Offline

#18 2017-06-11 12:15:47

miab3
Member
From: Poland
Registered: 2014-10-01
Posts: 188

Re: My test 15 - External DB performance and ZEOS 7.2-beta

e.g.
ODBC:OleDB:
'DRIVER={SQL Server Native Client 11.0};Server=SERVER\SQLEXPRESS;Database=master;Uid=user;Pwd=password;MARS_Connection=yes'
ODBC:
'DRIVER={ODBC Driver 13 for SQL Server};Server=SERVER\SQLEXPRESS;Database=master;Uid=user;Pwd=password;MARS_Connection=yes'

Last edited by miab3 (2017-06-12 12:14:13)

Offline

#19 2017-06-11 12:47:21

miab3
Member
From: Poland
Registered: 2014-10-01
Posts: 188

Re: My test 15 - External DB performance and ZEOS 7.2-beta

Running tests using Synopse mORMot framework 1.18.3684, compiled with Delphi 10 Seattle, against SQLite 3.17.0, at 2017-06-11 14:37:05.
ZEOSlib 7.3 svn 3978
UniDAC 7.0.2

Insertion speed

 			Direct	Batch	Trans	Batch Trans
SQLite3 (file full)	114	4037	25570	72882
SQLite3 (file off)	138	9021	53396	206927
SQLite3 (file off exc)	21507	189559	50923	139314
SQLite3 (mem)	59344	232959	74805	154841
TObjectList (static)	154635	348967	102633	265181
TObjectList (virtual)	121621	325097	152234	326733
SQLite3 (ext full)	58	2233	55208	31312
SQLite3 (ext off)	118	3299	58428	194696
SQLite3 (ext off exc)	31444	178393	61732	201873
SQLite3 (ext mem)	59670	221650	79743	129829
ZEOS SQlite3		60	1139	25151	37976
FireDAC SQlite3		9570	15477	36853	85142
UniDAC SQlite3		58	836	18833	26196
ODBC MSSQL2012		1547	11531	2083	15905
UniDAC MSSQL2012	1517	16792	1796	20062
ZEOS ODBC_W MSSQL2012	1522	32306	2247	32976
ZEOS ODBC_A MSSQL2012	1733	40470	2190	33862
ZEOS OleDB MSSQL2012	1639	7212	2315	41795
FireDAC MSSQL2012	1419	6633	2342	35987
ZEOS Firebird		417	8167	5719	8150
ZEOS PostgreSQL		918	16483	2139	17043
FireDAC PostgreSQL	802	15080	2001	13429
UniDAC PostgreSQL	490	6564	803	8997
ZEOS MySQL		2177	20076	2334	26144
FireDAC MySQL		1563	27880	1821	31115
UniDAC MySQL		2133	16483	2301	17258

Read speed

 			By one	All Virtual	All Direct
SQLite3 (file full)	9560	502664	489332
SQLite3 (file off)	9666	502260	499950
SQLite3 (file off exc)	76029	470322	499950
SQLite3 (mem)		59154	488472	504999
TObjectList (static)	109880	739535	698031
TObjectList (virtual)	153214	400128	696669
SQLite3 (ext full)	70790	252105	494657
SQLite3 (ext off)	92388	263601	491593
SQLite3 (ext off exc)	77553	223493	429959
SQLite3 (ext mem)	91910	237993	470987
ZEOS SQlite3		41619	203848	342371
FireDAC SQlite3		5783	98656	139844
UniDAC SQlite3		1689	79473	106796
ODBC MSSQL2012		2309	52682	199060
UniDAC MSSQL2012	1612	106042	168163
ZEOS ODBC_W MSSQL2012	1157	77278	153125
ZEOS ODBC_A MSSQL2012	1190	93353	150543
ZEOS OleDB MSSQL2012	2324	155768	291086
FireDAC MSSQL2012	1639	111423	159815
ZEOS Firebird		22574	97019	132044
ZEOS PostgreSQL		1941	81329	126553
FireDAC PostgreSQL	416	34732	45187
UniDAC PostgreSQL	196	56491	99111
ZEOS MySQL		2279	77811	176006
FireDAC MySQL		1335	46214	70106
UniDAC MySQL		1745	89455	125398

Michal

Last edited by miab3 (2017-06-11 12:48:44)

Offline

#20 2017-06-12 07:39:51

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,182
Website

Re: My test 15 - External DB performance and ZEOS 7.2-beta

Thanks for testing with the latest version of the framework!

I didn't expect any performance change, but we may have introduced some regressions.

Offline

#21 2017-06-12 10:12:35

houdw2006
Member
Registered: 2015-05-23
Posts: 48

Re: My test 15 - External DB performance and ZEOS 7.2-beta

miab3 wrote:

e.g.
OleDB:
'DRIVER={SQL Server Native Client 11.0};Server=SERVER\SQLEXPRESS;Database=master;Uid=user;Pwd=password;MARS_Connection=yes'
ODBC:
'DRIVER={ODBC Driver 13 for SQL Server};Server=SERVER\SQLEXPRESS;Database=master;Uid=user;Pwd=password;MARS_Connection=yes'

Thank you. @miab3.

My backend MSSQL is MSSQL2016.  I tried the above strings, and It seems not work.

Then I compiled the whole ZEOS package V7.3-alpha. By using the TZConnection, TZQuery components, I found that the value for parameter Url of function TZDriverManager.GetConnectionWithParams(const Url: string; Info: TStrings):  IZConnection;
  is a quite long string: zdbc:OleDB://127.0.0.1:1433/Provider=SQLOLEDB.1'#9'Password=XXXX'#9'Persist Security Info=True'#9'User ID=YYYY'#9'Initial Catalog=ZZZZ'#9'Data Source=127.0.0.1?username=UUUU;password=PPPP'

So I give the following string in UI of SynDBExplore as: OleDB://127.0.0.1:1433/Provider=SQLOLEDB.1, and found that when SynDBZeos call
GetConnectionWithParams, the Url is just about the same.
    zdbc:OleDB://127.0.0.1:1433/Provider=SQLOLEDB.1?username=UUUU;password=PPPP;controls_cp=CP_UTF8

The TZConnection, TZQuery works in Win64. But when combined zeos with mORMot, the Zeos raised a lot of exceptions such as EZSQLException OLEDB Error 80040E14 and Can't found the datatype CLOB. I use RawUTF8 datatype for UTF-8 Strings. 

What is wrong for my usage of SynDBZeos and Zeos?

Last edited by houdw2006 (2017-06-12 10:28:35)

Offline

#22 2017-06-12 12:10:58

miab3
Member
From: Poland
Registered: 2014-10-01
Posts: 188

Re: My test 15 - External DB performance and ZEOS 7.2-beta

OleDB:
'Provider=SQLNCLI11.1;User ID=user;Initial Catalog=master;Data Source=SERVER\SQLEXPRESS;Password=password;MarsConn=Yes'
zeos.inc from ZEOS in directory mORMot

Last edited by miab3 (2017-06-12 12:22:01)

Offline

Board footer

Powered by FluxBB