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.
>
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement