CodeTyphon ver 4.90 rebuilt without a problem. LazSqlX 4.0.3.1286-Win-32/64-bit build with success.
Firebird 2.5.3, MySQL 5.5.35, MariaDB 5.5.35, PostgreSQL 9.3.0, Oracle XE 11.2g, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, SQLite 3.7.17.
Running tests using Synopse mORMot framework 1.18, compiled with Delphi XE2-32.
Firebird 2.5.3(localhost), Oracle XE 11.2g(localhost), PostgreSQL 9.3.0(localhost), MariaDB 5.5.35(localhost).
Code: Select all
{
"Engine": "ZEOS Firebird",
"CreateTableTime": "195.44ms",
"NumberOfElements": 5000,
"InsertTime": "1.83s",
"InsertRate": 2731,
"InsertBatchTime": "194.90ms",
"InsertBatchRate": 25653,
"InsertTransactionTime": "807.83ms",
"InsertTransactionRate": 6189,
"InsertBatchTransactionTime": "195.24ms",
"InsertBatchTransactionRate": 25609,
"ReadOneByOneTime": "1.00s",
"ReadOneByOneRate": 4976,
"ReadAllVirtualTime": "78.84ms",
"ReadAllVirtualRate": 63415,
"ReadAllDirectTime": "56.95ms",
"ReadAllDirectRate": 87782,
"ClientCloseTime": "19.82ms"
}
{
"Engine": "AnyDAC Firebird",
"CreateTableTime": "116.37ms",
"NumberOfElements": 5000,
"InsertTime": "561.83ms",
"InsertRate": 8899,
"InsertBatchTime": "221.78ms",
"InsertBatchRate": 22544,
"InsertTransactionTime": "631.11ms",
"InsertTransactionRate": 7922,
"InsertBatchTransactionTime": "217.97ms",
"InsertBatchTransactionRate": 22938,
"ReadOneByOneTime": "5.43s",
"ReadOneByOneRate": 920,
"ReadAllVirtualTime": "158.16ms",
"ReadAllVirtualRate": 31611,
"ReadAllDirectTime": "124.49ms",
"ReadAllDirectRate": 40161,
"ClientCloseTime": "11.73ms"
}
{
"Engine": "UniDAC Firebird",
"CreateTableTime": "115.34ms",
"NumberOfElements": 5000,
"InsertTime": "2.92s",
"InsertRate": 1706,
"InsertBatchTime": "723.14ms",
"InsertBatchRate": 6914,
"InsertTransactionTime": "3.03s",
"InsertTransactionRate": 1645,
"InsertBatchTransactionTime": "757.81ms",
"InsertBatchTransactionRate": 6597,
"ReadOneByOneTime": "5.75s",
"ReadOneByOneRate": 869,
"ReadAllVirtualTime": "110.12ms",
"ReadAllVirtualRate": 45405,
"ReadAllDirectTime": "80.69ms",
"ReadAllDirectRate": 61958,
"ClientCloseTime": "20.15ms"
}
{
"Engine": "Oracle",
"CreateTableTime": "1.81s",
"NumberOfElements": 5000,
"InsertTime": "3.79s",
"InsertRate": 1316,
"InsertBatchTime": "93.67ms",
"InsertBatchRate": 53376,
"InsertTransactionTime": "1.45s",
"InsertTransactionRate": 3429,
"InsertBatchTransactionTime": "102.08ms",
"InsertBatchTransactionRate": 48977,
"ReadOneByOneTime": "1.08s",
"ReadOneByOneRate": 4617,
"ReadAllVirtualTime": "60.44ms",
"ReadAllVirtualRate": 82723,
"ReadAllDirectTime": "38.76ms",
"ReadAllDirectRate": 128995,
"ClientCloseTime": "106.46ms"
}
{
"Engine": "ZEOS Oracle",
"CreateTableTime": "415.43ms",
"NumberOfElements": 5000,
"InsertTime": "3.88s",
"InsertRate": 1286,
"InsertBatchTime": "186.80ms",
"InsertBatchRate": 26766,
"InsertTransactionTime": "1.52s",
"InsertTransactionRate": 3281,
"InsertBatchTransactionTime": "145.87ms",
"InsertBatchTransactionRate": 34274,
"ReadOneByOneTime": "1.05s",
"ReadOneByOneRate": 4752,
"ReadAllVirtualTime": "60.85ms",
"ReadAllVirtualRate": 82169,
"ReadAllDirectTime": "44.71ms",
"ReadAllDirectRate": 111826,
"ClientCloseTime": "37.13ms"
}
{
"Engine": "AnyDAC Oracle",
"CreateTableTime": "718.57ms",
"NumberOfElements": 5000,
"InsertTime": "4.19s",
"InsertRate": 1191,
"InsertBatchTime": "177.05ms",
"InsertBatchRate": 28240,
"InsertTransactionTime": "1.35s",
"InsertTransactionRate": 3689,
"InsertBatchTransactionTime": "146.70ms",
"InsertBatchTransactionRate": 34081,
"ReadOneByOneTime": "2.37s",
"ReadOneByOneRate": 2103,
"ReadAllVirtualTime": "116.94ms",
"ReadAllVirtualRate": 42754,
"ReadAllDirectTime": "85.39ms",
"ReadAllDirectRate": 58554,
"ClientCloseTime": "39.82ms"
}
{
"Engine": "UniDAC Oracle",
"CreateTableTime": "295.75ms",
"NumberOfElements": 5000,
"InsertTime": "4.68s",
"InsertRate": 1067,
"InsertBatchTime": "1.39s",
"InsertBatchRate": 3587,
"InsertTransactionTime": "1.97s",
"InsertTransactionRate": 2526,
"InsertBatchTransactionTime": "1.41s",
"InsertBatchTransactionRate": 3533,
"ReadOneByOneTime": "3.30s",
"ReadOneByOneRate": 1512,
"ReadAllVirtualTime": "118.55ms",
"ReadAllVirtualRate": 42175,
"ReadAllDirectTime": "89.28ms",
"ReadAllDirectRate": 55998,
"ClientCloseTime": "44.87ms"
}
{
"Engine": "ZEOS PostgreSQL",
"CreateTableTime": "225.60ms",
"NumberOfElements": 5000,
"InsertTime": "2.91s",
"InsertRate": 1717,
"InsertBatchTime": "301.73ms",
"InsertBatchRate": 16571,
"InsertTransactionTime": "986.70ms",
"InsertTransactionRate": 5067,
"InsertBatchTransactionTime": "247.36ms",
"InsertBatchTransactionRate": 20213,
"ReadOneByOneTime": "1.04s",
"ReadOneByOneRate": 4775,
"ReadAllVirtualTime": "76.36ms",
"ReadAllVirtualRate": 65475,
"ReadAllDirectTime": "51.59ms",
"ReadAllDirectRate": 96918,
"ClientCloseTime": "26.17ms"
}
{
"Engine": "AnyDAC PostgreSQL",
"CreateTableTime": "81.29ms",
"NumberOfElements": 5000,
"InsertTime": "2.99s",
"InsertRate": 1667,
"InsertBatchTime": "355.76ms",
"InsertBatchRate": 14054,
"InsertTransactionTime": "987.09ms",
"InsertTransactionRate": 5065,
"InsertBatchTransactionTime": "352.21ms",
"InsertBatchTransactionRate": 14195,
"ReadOneByOneTime": "4.16s",
"ReadOneByOneRate": 1201,
"ReadAllVirtualTime": "145.23ms",
"ReadAllVirtualRate": 34426,
"ReadAllDirectTime": "110.92ms",
"ReadAllDirectRate": 45074,
"ClientCloseTime": "29.53ms"
}
{
"Engine": "UniDAC PostgreSQL",
"CreateTableTime": "82.61ms",
"NumberOfElements": 5000,
"InsertTime": "4.08s",
"InsertRate": 1223,
"InsertBatchTime": "471.86ms",
"InsertBatchRate": 10596,
"InsertTransactionTime": "2.17s",
"InsertTransactionRate": 2299,
"InsertBatchTransactionTime": "420.89ms",
"InsertBatchTransactionRate": 11879,
"ReadOneByOneTime": "11.10s",
"ReadOneByOneRate": 450,
"ReadAllVirtualTime": "123.22ms",
"ReadAllVirtualRate": 40576,
"ReadAllDirectTime": "84.65ms",
"ReadAllDirectRate": 59061,
"ClientCloseTime": "35.91ms"
}
{
"Engine": "ZEOS MySQL",
"CreateTableTime": "71.91ms",
"NumberOfElements": 5000,
"InsertTime": "4.84s",
"InsertRate": 1031,
"InsertBatchTime": "374.22ms",
"InsertBatchRate": 13360,
"InsertTransactionTime": "844.48ms",
"InsertTransactionRate": 5920,
"InsertBatchTransactionTime": "258.85ms",
"InsertBatchTransactionRate": 19315,
"ReadOneByOneTime": "8.16s",
"ReadOneByOneRate": 612,
"ReadAllVirtualTime": "56.45ms",
"ReadAllVirtualRate": 88566,
"ReadAllDirectTime": "41.69ms",
"ReadAllDirectRate": 119924,
"ClientCloseTime": "18.62ms"
}
{
"Engine": "AnyDAC MySQL",
"CreateTableTime": "44.68ms",
"NumberOfElements": 5000,
"InsertTime": "4.91s",
"InsertRate": 1018,
"InsertBatchTime": "245.86ms",
"InsertBatchRate": 20336,
"InsertTransactionTime": "1.08s",
"InsertTransactionRate": 4618,
"InsertBatchTransactionTime": "243.61ms",
"InsertBatchTransactionRate": 20523,
"ReadOneByOneTime": "2.56s",
"ReadOneByOneRate": 1950,
"ReadAllVirtualTime": "113.78ms",
"ReadAllVirtualRate": 43942,
"ReadAllDirectTime": "80.40ms",
"ReadAllDirectRate": 62182,
"ClientCloseTime": "32.82ms"
}
{
"Engine": "UniDAC MySQL",
"CreateTableTime": "38.11ms",
"NumberOfElements": 5000,
"InsertTime": "4.90s",
"InsertRate": 1018,
"InsertBatchTime": "394.30ms",
"InsertBatchRate": 12680,
"InsertTransactionTime": "915.46ms",
"InsertTransactionRate": 5461,
"InsertBatchTransactionTime": "343.25ms",
"InsertBatchTransactionRate": 14566,
"ReadOneByOneTime": "2.06s",
"ReadOneByOneRate": 2424,
"ReadAllVirtualTime": "78.59ms",
"ReadAllVirtualRate": 63615,
"ReadAllDirectTime": "52.82ms",
"ReadAllDirectRate": 94648,
"ClientCloseTime": "13.90ms"
}
In Test15-mORMot ZEOS 7.2-alpha branches_ testing_r3281 is usually faster than the alternative libraries.