Information générale
Titre:
How long will this take in Sql Server/Oracle
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement