Opinions required on quickest way to display data

Hi,
I am currently working on a front end for an Access database which will be read over a network by a number of users. An SQL query is created from users input and the resultant recordset is displayed. I've currently looked at two methods.

1) Creating a recordset in code using ADO and then 'manually' filling a FlexGrid control by looping though the recordset. This is quicker for a small number of records. Or
2) Binding a DataGrid control to a ADODC control at design time and updateing the ADODC control's recordsource property with the SQL string. This tends to take the same amount of time (roughly) to return a few records or thousands, hence most of the time it's slower than the above but on occasion it out performs it.

I'll probably end up combining the two methods, but I was wondering what other peoples experiences were with this problem and if there are alternatives I haven't looked at yet.

Thanks a lot
Phil

I haven't had much experience with that but I'll offer my opinion anyways.

Do you have a sensation for what the majority of your users will be doing? Large or small requests? Then code appropriately. If 80% are small requests then you should use option 1 as the general user response will be "WOW...that was quick!", if the majority go with the LARGE ones then #2 is probably your better bet.

If you don't really know I would favour #1.

HTH /images/icons/smile.gif



Quote of the moment....
"My job is so top secret even I don't know what I'm doing!"

I would advise the first method. It gives you a lot more flexiblity in terms of making changes to your tables and to the appearance of your grid.

I agree.
The first method will offer you with more optons and it should, I repeat should, be faster.

-cl

Thanks for all your opinions, for the record I decided on the first method with a limit on the size of the returned recordset of 1000 records.
Thanks again
Phil