Fastest way to get thousands of db records to client in 3 tier?

[R. Alan Monroe]

In article <3f71361f$0$97182$edfadb0f at dread12.news.tele.dk>, Max M <maxm at mxm.dk> wrote:

>> I intend to write both client and server in Python, and my main goal 
>> in the first cut is speed. Suggestions?

>Why do you need thousand of rows at the client? Normally you would get 
>the results in batches, so that you only transfer at most a few hundred 
>at a time to the client.

Those types of tests will be done in my second cut.


>Why not let the client ask directly if it is faster?

I thought that defeats the purpose of having 3 tiers. You'd have to 
update the client if/every time business rules changed. Unless I'm 
missing something. Links to tutorials welcome.

Alan