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 queries these controls are using? Using the
LogPrepare
connection flag can help reveal the queries. In that case, the connection
string
would look something like:
SQLiteConnection connection = new SQLiteConnection(
"Data Source=test.db;Flags=LogPrepare;");
Please note that you will need a TraceListener setup in order to be able to
see the output generated by this connection flag.
>
> Anyway, the page loads and the grids populate nearly instantaneously on
the
> development machine under VS2012, but when deployed to WinServer 2012, it
> can take more than 20 seconds to populate the grids.
>
Is the database file on a network share? How many connections are trying to
access the database concurrently?
Perhaps the server is missing some patches to the .NET Framework? Maybe the
server has other issues (e.g. file-system corruption, hardware issues, etc)
that cause problems running System.Data.SQLite? Is there any trouble seen
in
the event logs?
>
> Note: Both machines are x64 and using NF4.0. Also, could only get ANY
> of many versions of System.Data.SQLite.dll that I tried on WINServer 2012
by
> configuring the AppPool to allow 32 bit execution. I don't understand
that
> either. .dll is located in /Bin folder.
>
There are x64 builds of System.Data.SQLite that should work in a native
64-bit
process on Windows Server.
--
Joe Mistachkin
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
