Service crawling on server 2008 web

[Martin-Emerson]

Hi Guys,

I've created a service to automate the import of data for one of our customers in an xml format. Everything is working fine on my XP test machine, I installed the service on the server (2008 server web) i'm intending it to run on full time and the app is now crawling along. On the test machine it took around 40 seconds a file, the server is taking upwards of 10 minutes.

I'm developing in VS 2005, any help and advice would be much appreciated.

Thanks,

Martin

 

[Martin-Emerson]

Crawled to a Halt

OK,

I found i was having problems with the database it's self, so I've moved from access to SQL express and reworked my import routine to be more efficent.

I've tested my import routine on 150 files with no issues on my XP client. Have tested again on my 2k8 server and it's failing to import at all now.

Can anyone offer any advice please?

I'm guessing there's somthing i'm not doing or somthing i need to do that i'm not, but i don't know where to start looking.