First, excuse-me for my poor english ok?
Pentium DUAL CORE 2,5ghz
RAD STudio XE (updated)
Not Anti-Virus installed
Not Other software in memory, when programing!
I use in my projects, FIBPLus 7.0.15 and FIREBIRD 2.5 (conection TCP in same pc with RADSTudioXE, I dont use network system pc, CharSet = iso-8859-1 or NONE)
I would like change for UniDAC for know who is who? (in performance)
In FIBPLUS, i use: (commit in 2 phase)
fibdatabase + 2 fibtransaction (1 = ready-only (readrepetable), 1 = write )
Transactions in InterBase/Firebird: how to use them in FIBPlus (part 2)
fibtransaction READ-ONLY (READ COMMITTED ) open all time
isc_tpb_read <--- i changed here, before was isc_tpb_write)
fibtransaction WRITE (SNAPSHOT) short-time for write changes
fibdataset use 2 transactions (1=ready-only open all time, 1=write, just in edit, delete, post records )
the fibtransaction WRITE, i use for REFRESHUPDATES
In UniDAC, how will be this CUSTOM-TRANSACTION?
how can i insert one custom-transaction type?
How can i use it in UniTable?
In FIBPLUS, i can use fibtrasaction.INTRASANCTION for to know if the transaction is Active, but, in UniDac components, i have to use UniConnection for this task.
How to know if TrRO or TrRW is ACTIVE if I have to use UniConnection for this task?
In FIBPLUS, i use TrRO.INTRANSACTION and TrRW.INTRANSACTION. I dont use FIBDATABASE.InTransaction (where is the string of connection with the database = UniConnection component)
in first test, I make one table (CITY) with fields:
ID = bigint, Name = varchar(40) , UF = char(2)
I Inserted 1.000.000 record for test
I used Delphi XE with cxGrid (DevExpress 2.4) in 2 forms, 1 = FIBPLUS and 1 UNIDAC, to access FIREBIRD DB 2.5
cxGrids = GridMode = True, SmartRefresh, BufferRecords = 25lines(records), so, I dont used FETCHED ALL RECORD ok? jUST 25 record in OPEN table, in the forms. cxGrid in GRIDMODE is equal DBGrid (vcl delphi), load only "n" records = row grid
Time Open: +/- 0.7seconds in FIB and UNI components = OK!
But, in the browse, from 1 to 1.000.000 record: (ctrl+end key)
FibPlus: 7,5 seconds
UniDac: 11,4 seconds
I use some combinations UniDac, but always there was a diference +/- 2,5 seconds between Fib And UNI
--- QueryRecordCounts = off
--- not detail tables
--- just options default
--- any others combinations
Can you help me in this task?
-- FIBDatabase (connection)
-- FIBTransacton1 (ready-only)
-- FIBTransacton2 (write)
-- FIBdataset1 (table)
--UniTransaction1 (READ COMMITTED)
-- cxGrid in gridmode=true, smartrefresh, bufferrecords=25
-- DBGrid (delphi native grid)
For counting time
-- function WinAPI (QueryPerformanceFrequency, QueryPerformanceCounter) updated for XE use
Note: I just use BROWSING the datas, i dont write nothing in the table
Thanks for your time,