>There is allways some compromise to do. 3-tier architecture is more flexible that a monolitic app, but it's generally slower.
>
>To get a list of records, you can:
>- Have a method in the business layer that pull out all the records needed and have methods to get each receords separately (GetNext(), GetPrevious(), etc.) So you can build a cursor in your presentation layer and fill it out with successive calls to the GetNext() method
>- Use ADO to pass recordset between the layers
>
>>I donnot really want to bypass the business layer. I am only curious how to pull data through this layer in the most effective way (i.e. speed)

Thankx Sylvain!

That's what I was afraid of!

BB