Re: [Firebird-net-provider] Slow query

2017-02-23 Thread Berko Bubu 
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
   (Query.FieldByName('F1').AsString='???') or
   (Query.FieldByName('F2').AsString='???') or
   (Query.FieldByName('F3').AsString='???') or
   (Query.FieldByName('F4').AsString='???') then Caption:='ok';
Query.Next;
  end;
d2:=now;
showmessage(inttostr(Query.RecordCount)+':'+inttostr(MilliSecondsBetween(d2,d1)));
Tran.Commit;

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Slow query

2017-02-23 Thread Jiří Činčura 
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
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Slow query

2017-02-23 Thread Berko Bubu 
> > 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 between C# and Delphi decrease.


Berko

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Slow query

2017-02-23 Thread Jiří Činčura 
> 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

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider