>Hi, all
>
>Why my application is slow?
>
>my application is Using VFP ODBC DRIVER (Ver5.0)
>
>Main DATABASE is Visual Foxpro Database (DBC) -> SERVER
>
>Client using Remote view AND SPT(Sql Passing Throughout) -> CLIENT
Can you give us a little more information as to the specifics?
I can think of a few things such as poor indexing (or none), network congestion, or non-optimized SQL calls that you're passing. It's really kind of difficult to offer advice without knowing a little bit more about your situation.
In the interim, check the indexes on the database tables. Run tests when you know the network isn't congested to make sure that that isn't an issue. I'd also run different SQL calls through it to see where your bottleneck is. Start with something very simple (i.e. select custno from customer where custno > 1000 , a simple single table query) and slowly move up in complexity (and answerset size) from there.
Christopher
Christopher Estep
When the student is ready, the master appears.
-- Chinese Proverb