Cirstof,
>
>>Poor man's SQL Server. Actually, if the data is on the same machine as the COM Server, you may get faster data access than SQL Server.
>
>Yes, but speed is drastically reduced, if this table are accessed by any other station, too. IOW, if they are not opened exclusively, because then any modification would force VFP to re-read the index, something SQL server has got to do. Therefore SQL server can indeed beat VFP in speed, especially if the server is designed for SQL server, having much RAM and fast disk access.
>

If a table is not opened exclusively it could be that this won't affect performance. A NT server can use Exclusive oplocks to provide a sort of exclusive mode even when you opened the table with the SHARED clause or having SET EXCLISUVE OFF.

Like you noted, Even if this tables is used by another user It only seems to reread the index when any modification was made to the table. I'm curious how this internally works.

Walter,