Running ANALYZE Command using the ADO provider

Last post 09-10-2010 2:42 AM by mort. 2 replies.

Page 1 of 1 (3 items)
	Sort Posts: Previous Next

09-01-2010 3:43 AM

mort
Joined on 09-01-2010
Posts 2

Running ANALYZE Command using the ADO provider

Reply Contact

Should we be able to call the 'ANALYZE' command using the ExecuteScalar method on a SqliteCommand. Currently when we attempt this we get the following message:

Could not find stored procedure 'ANALYZE'

The command runs successfully using the Sqlite3.exe and improves performance no end.

We are using version 1.0.66.0 of System.Data.SQLite.

This issue asside we are well impressed by SQLite and the ADO provider. So fast.....

09-01-2010 11:59 AM In reply to

ThomasD
Joined on 03-20-2010
Posts 8

Re: Running ANALYZE Command using the ADO provider

Reply Contact

Please provide some source code!

It should work like this:

SQLiteCommand cmd = new SQLiteCommand("ANALYZE", conn);
cmd.ExecuteNonQuery();

Thomas

09-10-2010 2:42 AM In reply to

mort
Joined on 09-01-2010
Posts 2

Re: Running ANALYZE Command using the ADO provider

Reply Contact

Realy sorry about this but 99% sure that it is my 'bad'. When i reduced the code to it's basics it all works.

The bug is somewhere in our abstraction layer for cross database support, just cannot figure out where.....

Appologies

Martyn

Page 1 of 1 (3 items)