Re: [Firebird-net-provider] Asynchronous query execution available?

2008-03-03 Thread Mathias Wührmann
Hi André, André Knappstein, Controlling schrieb: please be kind with me if the following advice is boring for you, but you mentioned that you are migrating from Access. there is nothing boring about your advice, even if I knew some of those things before ;-) But a query like the one you

Re: [Firebird-net-provider] Asynchronous query execution available?

2008-02-26 Thread André Knappstein , Controlling
Matthias, please be kind with me if the following advice is boring for you, but you mentioned that you are migrating from Access. I am active in teaching developers how to migrate from dBase DBFs, which in general have a lot of similarities with Access MDBs. The biggest mistake I have to

[Firebird-net-provider] Asynchronous query execution available?

2008-02-25 Thread Mathias Wührmann
Hi there, is asynchronous query execution possible with Firebird 2.0 or is this feature just not available in .NET-Provider? Regards, Mathias Wührmann - This SF.net email is sponsored by: Microsoft Defy all challenges.

Re: [Firebird-net-provider] Asynchronous query execution available?

2008-02-25 Thread Mathias Wührmann
To be more specific, I'm talking about fetching records asynchronously. I was able to find information about async execution for INSERT/UPDATE, but not about retrieving records with SELECT. - This SF.net email is sponsored

Re: [Firebird-net-provider] Asynchronous query execution available?

2008-02-25 Thread Jiri Cincura
On 2/25/08, Mathias Wührmann [EMAIL PROTECTED] wrote: I was able to find information about async execution for INSERT/UPDATE, but not about retrieving records with SELECT. What do you meam? When you have executed query, you have DataReader and you can fetch records from it whatever you want.

Re: [Firebird-net-provider] Asynchronous query execution available?

2008-02-25 Thread Mathias Wührmann
Hi, Jiri Cincura schrieb: What do you meam? When you have executed query, you have DataReader and you can fetch records from it whatever you want. sorry if my posting was not well understandable. I'm porting a software from VB6 and MS Access to VB.NET and Firebird database. The database has

Re: [Firebird-net-provider] Asynchronous query execution available?

2008-02-25 Thread Jiri Cincura
On 2/25/08, Mathias Wührmann [EMAIL PROTECTED] wrote: Just like I was doing it with MS Access, I want to fetch these records asynchronous, so that I do not need to wait until all 250 records are retrieved and can start viewing the result after some of the first records are processed.

Re: [Firebird-net-provider] Asynchronous query execution available?

2008-02-25 Thread Madhu Sasidhar, MD
Mathias, Please check your query syntax and Db (indexes and keys). Even the most complex JOINS with 1 records returned in my VB.NET does not take more than a few milliseconds. You may have to optimize your Db/SP or query. MS

Re: [Firebird-net-provider] Asynchronous query execution available?

2008-02-25 Thread Mathias Wührmann
Hi Jiri, Jiri Cincura schrieb: FirebirdClient isn't fetching all records. It gets you DataReader as far as the record has been processed and reading DataReader fetches next records (well DR isn't fetching record self, the underlying classes doing this, but DR is calling these methods).

Re: [Firebird-net-provider] Asynchronous query execution available?

2008-02-25 Thread Jiri Cincura
On 2/25/08, Mathias Wührmann [EMAIL PROTECTED] wrote: da.Fill(dt) This simply fills your dataset/datatable, so *after* it's filled, the binding to some UI component is done = records are shown. Using DataReader can bring some benefit, but you will need to write some logic by