SQL CE Insert Performance

  • Thread starter Thread starter info
  • Start date Start date
I

info

Hi there

With what duration do I have to calculate when inserting about 10000
Rows in the SQL CE Database?

Thanks
 
If you use prepared command with parameters - I'd say tens of seconds to
several minutes. This is only a guess of course as the time greatly depends
on indexes (the more indexes - the slower insert is), data types (int - very
fast. Image - very slow) and a number of fields. Finally, the device itself
is of course a factor as they all have different clock speed.
 
Well, I was going to mention that but since my belief is that it's
extrememly bad idea to use a flash storage for read/write database (at least
a storage card), I decided not to at the end.
 
I'm afraid to ask: why are against putting a read/write database on a
storage card?
I could think of some reasons, but there are also some arguments for
doing so.
 
Primarily performance. This may become less of an issue with the new faster
cards (such as Sandisk Ultra and Extreme, or Lexar Pro). Another factor is
limited lifetime of a flash card especially with regard to number of writes.
Again, newer cards may be more robust
 
And the huge possibility of corrupting the entire thing if the device is put
to sleep or reset during a write, or if the card is pulled during a write.

--
Chris Tacke
Co-founder
OpenNETCF.org
Has OpenNETCF helped you? Consider donating to support us!
http://www.opennetcf.org/donate
 
Very good points. Having some apps with very large data stores (almost
impossible to rebuild remotely), removable storage has been a safe bet
for me in the past. Hopefully SQL mobile will be as uncorruptable as
claimed, mitigating some of these concerns.
 
The concern isn't SQL Mobile, it's the driver writing to the flash store
itself that's the issue. If the media has a controller that handles power
loss mid erase/write you'll be alright. If not, there's nothing SQL Mobile
can do about it.

-Chris
 
Thank you a lot for your answers they are very helpfull.

And what about in comparison the performance of an replication?
 
I'm not a big fan of Merg Rep, so I haven't done any testing with the
new stuff yet.
 
Chris Tacke said:
And the huge possibility of corrupting the entire thing if the device is
put to sleep or reset during a write, or if the card is pulled during a
write.
Click to expand...
But where would you store the database in an ofline scenario?

Marc
 
Back
Top