Zeoslib Portal

Hi regarding the optimization concern: the speedup is still there if I run the following loop FDataSet.Open('select * from DB.Table limit 30000'); while not FDataSet.EOF do begin s:= FDataSet.FieldByName('ID').AsString; if s='something' then showmessage(s); FDataset.Next; end; In the above loop the ...

Actually you are right. In this particular case using s := FDataSet.FieldByName('ID').AsString; does cut the time for loading 100 k records down to 0.7 secs But still. This must be a ZeosLib problem and not a Delphi problem :?: How do I know: well using other components such as MyDac, does not gener...

Hi Thank you for your response. Regarding the code: That is actually the code I have used. I had called the TReadOnlyQuery "dbc" but changed the name to FDataset when I posted the code here, so it would be easier to understand. I apologize that I had forgot to change the name everywhere, a...

Hi all I have a problem with TZReadOnlyQuery being too slow. I am loading app 50-100 K records, and it is taking upto 5-10 seconds. The exact same code has been used with Devarts MyDac and takes 0.2 seconds. Even if the connection method of MyDac is set through the LibMySQL.dll, it is the same way. ...

Hello Thank you for your reply. I do not need the portability feature. I am quite sure to stick to MySQL, so I will not implment Zeos due to the overhead that you describe. So thank you for this advice. I still think that Zeos is a good initiative, and I am always a fan of OpenSource projects. I wil...

Hello I am looking for reliable components to connect to MySQL from Delphi 7. I have tried the Scibit components, and found these (after two years) to be buggy, slow and with a lot of overhead. I am currently looking at the components from CoreLab, MicroOlap and ofcourse at Zeos. Can you please tell...