Arthur Fuller
fuller.artful at gmail.com
Sun Jul 22 15:01:14 CDT 2012
Were you using ODBC? ADP project format? Passing parameters to Insert stored procedures? IME, I have developed some pretty large apps using ADP format and stored procedures, and never experienced slow inserts, even with upwards of 75 simultaneous users. Arthur On Sun, Jul 22, 2012 at 3:35 PM, Mark Simms <marksimms at verizon.net> wrote: > Re: " speed is much better "....Sniff, sniff..boy, do I smell something. > My last benchmarks with Access with SQL Server backend had great speed For > RETRIEVALS (4x faster). Horrible speed for inserts (10x slower). > > This was back in the SQL Server 2000/2005 days. Naturally, this could have > changed with 2008. > > >