Je veux ajouter que nous faisons partie d'une grosse compagnie et il y a un département qui gère le réseau et les postes de travail. Le responsable de ce département dit que si le réseau est trop chargé c'est du au fais de l'utisation de Foxpro et des fichiers dbf qui sont des flat file et génère beaucoup de traffic entre le poste qui fais les traitements et le serveur. Il prétend que si on avait un vrai serveur de données ce ne serais pas le cas.

Michel

>Michel
>
>Please write in French if it's easier for you. I will reply in English however.
>
>From what you describe, it lok slike you are returning all the rows to the client side.
>
>Can you create a stored proc that returns only the data you wish? This would likely solve your issues.
>
>- Val
>
>
>>I will try to explain but because I am frech I have some difficulty to find the right word.
>>
>>People who work for our company (outside of the office and doing auditing) ask for some data about client (they send us a email with a request). When we receive the request a task is launch on a computer doing only this task to extract data from the main tables (about 12 tables and some of them are 1 to 1.5 gig ).
>>From those table we are extracting data using scan, select sql and other code to result table that are compress into a zip file and send to the person who have make the request by email. We can receive from 100 to 300 request on one day. During the process we are not locking table
>>
>>
>>Michel
>>
>>>Michel,
>>>
>>>We have a lot experience in this regard so we'll try to help out. That said, you did not provide any information on which to base an intelligent reply.
>>>
>>>What are you doing with the data?
>>>Can filter conditions apply?
>>>Are you locking any data?
>>>How large is the data?
>>>How are you returning to the client station?
>>>
>>>- Val Matison
>>>
>>>>Hi
>>>>
>>>>We have some heavy task using table that are on a server on the basement. The network speed is 10 mb. These task is taking more than 12 hours. In these task we are extracting some data, scanning table.......
>>>>
>>>>Foxpro table are flat file and someone told me that in this case this is doing lot of traffic on the network. In fact the processor of the computer doing these task is used about 2 to 14 % and the graphic about the network traffic is about 80 to 100%. The same person told me that using sql server for data will really make a big difference for the traffic on the network and the time for these task.
>>>>
>>>>I wish the have the advice from people who move to sql server and if this is true.
>>>>
>>>>Michel