From: Kixzo D. T. <ki...@4c...> - 2008-02-28 14:07:07
|
Hello, Thank you for your reply. I am fetching the record directly through a select Query. let me explain my table structure. I have one master table with User Information and "UserID" filed from this table is referenced in at most 25 tables and also the "UserID" Field is Indexed. And I am executing select query to select the data. What my concern is. I want results in Group of 100 records, like The result will return first 100 records then next 100 and so on, until the whole records are fetched. One solution for this is, first I get the record count and then get the result, but is taking time too, for getting the record count. So, is there any solution as I need. Regards, Rakesh Singh. -----Original Message----- From: Jiri Cincura [mailto:di...@ci...] Sent: Thursday, February 28, 2008 2:26 PM To: ki...@4c...; For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Query Result On 2/28/08, Kixzo Database Team <ki...@4c...> wrote: > What my problem is I Querying database from some result, the result dataset > is about 5K rows, which I had to display in the Listview control in my C# > application. > > It is taking about 10 to 11 seconds to fetch the record from the database > and same to populate the ListView control. Populating the list view control > Is not a problem. That can be managed. 10 seconds is a really long time. If I will not count execution time and suppose you're not oon slow line, then fetching these records and showing in ListView shouldn't take more than, say, 5 seconds max. What's the way how you fetching records and adding to LV? > What I want to ask is that, is there any way to get the results in counters > so that I can get results in group of 100 records, so that I can display the > data in Group of 100. What do you mean with "results in counters"? -- Jiri {x2} Cincura (CTO x2develop) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com |