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 resul

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 popula

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

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