>>>
>>>Yes I know that, I mean SEEK in Fox compared to EXISTS in Sql-Server.
>>
>>I've no idea how to compare SEEK in VFP with EXISTS in Sql Server. All I can say, that with EXISTS Sql Server doesn't select all records, that satisfied specified conditions, but looks for the first one only, which makes it vary close to the SEEK. You can emulate IF EXISTS in VFP and run some tests but I'm not sure that you can relate results to Sql Server EXSISTS command. See
Re: Not exists command Thread #
646918 Message #
646925.
>
>OK.
>
>The reason I need a comparison is that we may be putting out Fox data into Sql-Server, and I have some areas of the system that check for existence of records in many tables (using indexseek), and I need to know if it's going to be much different in terms of performance, in Sql-Server.
>
In this case you'll have to run your own tests to find out. You can also consider using Stored Procedures (SP) to do multiple checks with one call.
--sb--