>Hi Rick. Thanks for the input.
>
>How big is database and individual files?
>*.dbf = 730 meg
>*.cdx = 130 meg
>*.fpt = 43 meg
>
>The largest dbf is 234 Meg and has no memo file.
>
>Yes I have both databases (live and test) on the same server and the same HDD, just different folders and so from the workstation different drive mappings.
>
>I had tested it before but just to be sure, I dropped the drive mappings and remapped them swapping them. I then conducted the same test. Swapping the drive letters had absolutely no effect meaning Live is still slow versus Test. No difference at all.
>
>As for the same load meaning just me?
>This is a 24 hour "shop" meaning they are using the system 24/7.
>It is difficult to get everyone out but from the server I can use server manager to see who is logged in. I know their business and I know what each user is doing. I am taking all that into account. Having said that and to ensure my testing is valid:
>
>Stop the presses. I am trying to do some more test. It appears that if any large table is open, in the dbc, from which I am pulling data (from the workstation), it is effecting the query time.

Just FYI - if you have a DBC and are using views, VFP locks the record for the view each and every time you use the view or requery the view. This can have a performance effect when you finally get enough users.