I search DBGrid for 1 Million records...

[Mucan]

I search DBGrid components and it have "group field" property like Developer Express Grid(Express Quantum Grid). I don't use Quantum Grid because it's not supportd 1 million records (groupped). it's very slow after 10000 records.

And I search different Grid component.It's not load all records in Grid, it's load only visible records.if I change position scrollbar then load new visible records?

[MartinOaktree]

Hi,

I think the Time is spend in the Dataserver, and the server read all of the 1-Million Datarows.

If You use SQL,
try the requied SELECT SQL-Statement in a Console,
for Example in Interbase use ISQL or IBConsole.
Here You can test the Speed.

If speed is OK the use the tested SQL-Satement.

If the Command takes to much time, try an Index on the fields which is used in the ORDER BY clause, then the Database-Server has to read only the the Datarows which are read by the Client-Application (displayed in a Grid), when You scroll the Grid, then the next Rows are read.

So You reduce the Datavolume read in the Server and the traffic on the LAN.

Martin

[GoodFun]

what do you do with those 1 Million records??? If you nee them for display, then I'm sure there has to be a criteria by which to reduce the number of records.. I don't know any user who would be able to look at 1 Million records at the same time... actually, most users are already overwhelmed if they are presented with more than two screens of data.

If you need to records for processing, try to shift some of the processing to the server, i.e. make use of agregates function in SQL like SUM, AVG, COUNT, and so on...

if you give us a bit more info on what the data is and what you are trying to do with it, I'm sure we can give you a better way to handle the situation.

Hope this helps,

Marcel

<cr>Please click on Accept if this helped...</cr>