Hi,

I am woking on DotNetNuke for last 3/4 months and developing modules for a client. I want to insert 40,000 rows into a table when we load a DNN module on the site so that the data is available when the module is successfully loaded.

I tried various things:

[1] First I had all these inserts into SQL loader file along with other SQL statements

Problem: It was giving time-out when I tried to load it on the stagging server but worked OK on the local host

[2] Then I created a stored proc having 40,000 inserts in the SQL loader file which got created when the module was loaded. But then I had to execut that from soomewhere on the first page when user clicks on this FIRST time, which was also not that succeessful.

[3] Then I created a Scheduler job using 'Admin' rights and called this stored proc after the module was loaded.

Problem: It also started timing out

[4] So the I divided the 40,000 inserts - 1 store proc to 8/10 stored procs a having 4000/5000 inserts each. Then created 10 scheduler jobs and exceuted them one by one

Problem: It also started timing out

I have tried out several things and I am lost now. Surprisingly it works fine on local host - no problem but on staging servers it gives time-out prblem.

So my question is what is the BEST way to achieve this? All 40,000 rows should be inserted in a table when the module is getting loaded automatically...

PLEASE HELP, else I am loosing my client???????

Enviornment: MS -SQL Server 2000, DotNetNuke 3.x with ASP .Net 1.1

Thanks

Girish