Re: [sqlite] Significant Performance Problem with System.Data.SQLite.

2014-01-21 Thread Joe Mistachkin
Ed Tenholder wrote: > > I have never used a profiling tool. Have VS 2010 installed. > Depending on which edition of Visual Studio 2010 is installed, you may be able to simply use their managed code profiling tools. Thankfully, these tools are fairly straightforward to use and produce nice

[sqlite] Significant Performance Problem with System.Data.SQLite.

2014-01-21 Thread Ed Tenholder
I have never used a profiling tool. Have VS 2010 installed. A quick web search shows several available free tools. What do you recommend for VS 2010 and SQLite? Are you able to run the application with profiling enabled to determine

Re: [sqlite] Significant Performance Problem with System.Data.SQLite.

2014-01-20 Thread Joe Mistachkin
Ed Tenholder wrote: > > (5) There are at most three SqlDataSource controls on any page, and it is > possible that each would have the same data connection open simultaneously, > but all for read access, except when inserting or deleting a record. The > performance problem occurs when only

Re: [sqlite] Significant Performance Problem with System.Data.SQLite.

2014-01-20 Thread Ed Tenholder
will work with VS. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Monday, January 20, 2014 8:33 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Significant Performan

Re: [sqlite] Significant Performance Problem with System.Data.SQLite.

2014-01-20 Thread Joe Mistachkin
Ed Tenholder wrote: > > The asp.net app is several pages, each with from one to three datagrids that > are filled using ADO.NET. Very little actual code. Using GridView, > DetailsView, DropDownList, and SqlDataSource > (ProviderName="System.Data.SQLite") controls. > Do you know what kind of

[sqlite] Significant Performance Problem with System.Data.SQLite.

2014-01-20 Thread Ed Tenholder
I've finally finished converting from SQLserver Express to SQLite for an ASP.NET app on my development machine. VS 2010 Professional. System.Data.SQLite version 1.0.90.0, and 1.0.89.0 Got everything working great in development, but did I ever have problems deploying to Win Server 2012.