Loading

Database cleaning wizard

Kanhialal kk

Hi....

I am working on database cleaning wizard which contains 20 table to clean

all tables contains a unique id named InvoiceNo,, now i have created a storedprocedure in which i have passed all 20 query and a parameter of invoiceno
but when run run (UI) as I start cleaning process it takes too much time..
while tables contains thousands records.

so how it is possible to increase speed

..
Please help

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vishal Jadav14y ago
hellow,

try to use threading. start multiple threads as number to tables.
it will start cleaning the data all at a time.
0