>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

It also depend on you data volume. FoxPro native tables are flat and even INDEXSEEK passes through your data (index file) to find searched record. SQL organization is absolutely different. You could see this only if you have large amount of data.