When I am trying to use some of the FirebirdSql.Data.Services API (v5.6)
against a Firebird v2.5.6 database, such as;
- FirebirdSql.Data.Services.FbServerProperties.GetDatabasesInfo()
- FirebirdSql.Data.Services.FbSecurity.GetUsersDbPath()
I get the error:
"Service isc_info_svc_svr_db_info
How the Delphi code looks like?
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> > I feel, the number of records (or number of varchar columns) grows, so
> > does the difference between C# and Delphi.
>
> You feel or can you confirm it? Did you tried i.e. selecting just NULL?
I set null the F1-F5 fields, i get test result:
C# : ~ 110 ms
Delphi: ~ 50 ms
So the difference
My Delphi Code:
db.Open;
Query.Transaction.StartTransaction;
d1:=now;
Query.SQL.Text:='select i0,c1,f1,f2,f3,f4 from test';
Query.Open;
while not Query.Eof do
begin
if (Query.FieldByName('I0').AsInteger<0) or
(Query.FieldByName('C1').AsString='???') or
More info:
http://blog.cincura.net/233594-ado-net-provider-5-8-0-0-for-firebird-is-ready/
.
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Check out the vibrant tech community on one of the world's most
engaging tech
Hi,
I have a problem with performance of firebird net provider.
My query is slow.
In my table there are ~ 5000 records.
Simple query: select * from table
In case of IBExpert or Delphi program, it takes ~ 80 ms
In case of C# ~ 250 ms
I fetch all records in IBExpert and Delphi too.
I
Hi,
I terrible sorry of previous mail format. I try it again in plain text.
I have a problem with performance of firebird net provider.
My query is slow.
In my table there are ~ 5000 records.
Simple query: select * from table
In case of IBExpert or Delphi program, it takes ~ 80 ms
In case of
> I feel, the number of records (or number of varchar columns) grows, so
> does the difference between C# and Delphi.
You feel or can you confirm it? Did you tried i.e. selecting just NULL?
--
Mgr. Jiří Činčura
Independent IT Specialist
