Hi

I'm currently looking at performance of an app written in VFP, and whether it will be any different when it goes Client/Server.

There is 1 particular screen on this application, that contains 14 buttons on the screen. When the form is refreshed, each button checks 1 individual table each, to see if the current client the user is viewing, has any information stored on these tables.

With INDEXSEEK, this is a breeze and is very quick/efficient, what I want to know is how long this will take in a 3-tier sitution, each button would have to call a procedure in the middle-tier to return whether data exists, it will need to do this 14 times, each time the form is refreshed.

I can't check this for myself because I haven't got access to an Oracle/Sql DB, I was wondering if anyone had any idea if this would be slower/faster when the app is moved across?

BTW, 12 INDEXSEEKS on a network takes 0.02 seconds.

Thanks
Kev