Hi,
Have you tried dropping the index on the SQL Server tables and then recreating the index? Also run sp_recompile on the SQL Server table.
Paul
>Two SQL tables have text fields and we are inserting some memo chunks into these text fields (small character strings really, perhaps 200-250 chars on average).
>
>Initially there is no problem when starting the conversion, the SQL tables are empty and the tableupdates go in quickly as expected.
>
>These tables grow to a approx siz of 70 to 100,000 recs by the end.
>As they grow the process slows down incredibly.
>
>Even after the conversion, our new VFP6 app takes a ridiculous amount of time to update a record with our new app... and yes, our indexes are in place, etc.
>
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only