As an addition to my first message...
I've run a trace on the distribution to the local server and it looks like the subscription has been reinitialized and the data is being pushed out on a transaction basis..using the MSInsert procedures rather than the traditional way....the net effect is the subscriber takes an age to update...so I have to kill the agent and manually push out a new snaphot which runs in about 15 mins..
Does anyone have any thoughts on this ?
Many thanks...Graeme