We have developed a portable application for PENDRIVE media. Application is installed on pendrive and database is SQL-CE 3.5.

We are using sql Compact edition  the time taken by the plain insert statement in SQL CE is more than the time taken by the Oracle DB.

This is cosidered as a performance issue by our client. 

Please give us the solution to overcome this issue.

Thanks in advance.

Avoid the query processor, use SqlCeBulkCopy, sample code here: http://stackoverflow.com/questions/18703203/speed-up-parsing-of-xml-in-c-sharp-compact-framework-using-xmltextreader-xele, and do not open/close connections, but leave a connection open for the lifetime of the application.

Go Through below link

http://msdn.microsoft.com/en-us/library/dd938877.aspx#CodingRecordInsertionLogic