Re: Delphi 6 - ADO - MS SQL Server

Hello,
I have some hits. Their may be usefull.
1- StoredProcedures only affect handkshaking costs and simplifies repetitive
tasks.
2- Ususally in large DB systems after updaing records, in some cases you
should first disable or delete indexing engine. After that all of jobs were
done, then create indexes again (Here you can server stored procedures for
simplicity and modularity). The indexing task may be done in system idle
times eg nights.

If these were not usefull, inform me!




.