>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
>
>Server computer resource info
>-----------------------------
>Pentium 120Mhz
>RAM : 32M
>OS : Win95
>Network : NETBEUI
>
>Client computer resouce info
>-----------------------------
>Pentium 120Mhz
>RAM : 16M
>OS : Win95
>Network : NETBEUI

Along with the suggestions for programming optimization, I would suggest going with fater computers. I know this is sometimes easier said than done, but Pentium 120's are pretty slow computers by nowadaze standards...at least upgrade the RAM (I would first add RAM to the client and then to the server...the more the better). Also, Fast Ethernet (100Mbs) is no longer expensive...if you are not using it, that is one way to speed things up. I'd also suggest going to Windows NT if possible (maybe after upgrading the computers). I was never too impressed with Windows 95's networking.

Joe