SELECT - SQL.
>Dear All,
>
>I have Devopled a package for Medical Stores and it works fine as a single system. Now I have conveted to use the same as multi user. It works fine except for the Speed.The Speed is good in the system where the Database (free tables) are stored and Slow in all other systems
>
>I have only database "stock" which holds 40,000 records from Which I have filter to a particular record while doing the Sales. It Takes 15 to 20 Sec to get the item.
>
>Previousl I was using Locate command and then transfer them to bill table once the critiera is met ( it took 40 to 50 Sec).Now I am using Filter condition "SET Filter To Stock.Medicinename=Bill.Medicinename"It Takes 15 to 20 Sec and Is there any other Better method to avoid this time delay
>
>The Exe File is Copied in all the systems and using Set Path to Command I get the Data (Free Tables) from the Server
>
>Thanks For Your Help
>
>With Regards
>
>T.D.Muruganandam
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.