Help about choosing efficient database technology

[tenkyu]

Hi guys;
i am using SQLCE and CF 1.0 with win CE 4.1 (32mb memory) i have a
serious performance problem, when a query(not my app, with sqlce
query) my table (1400 records) it has been resulted 5 second.

Do you think think that is is normal for SQLCE, i usually develop web-
projects, i thought that it is SQLCE problem and googled on then web
and found a new database called SQLite, but i can't use it on the win
CE, can anybody help me about this topic.

Any offers about choosing best database (SQLite, SQLCE vice versa), if
you offer different from SQLCE could you send me a sample.

 

[Guest]

I'd start by simply adding an index to the table or tables you're querying.
SQLCE isn't the fastest thing out there, but it can certainly do better than
5 seconds on a 1400 record table .

Also, if it's not your app you're not going to be able to just swap out the
data engine. That requires a code change.


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Giving back to the embedded community
http://community.OpenNETCF.com

 

[tenkyu]

I'd start by simply adding an index to the table or tables you're querying..
SQLCE isn't the fastest thing out there, but it can certainly do better than
5 seconds on a 1400 record table .

Also, if it's not your app you're not going to be able to just swap out the
data engine.  That requires a code change.

--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Giving back to the embedded communityhttp://community.OpenNETCF.com








- Alýntýyý göster -

code changing is not important for me, because i am re-engineering
this project may i will re-write it.
index wouldn't make me faster because i don't use any criteria just
"select a,b,c from table;"

do you any offer for choosing fastest database technology?

 

[Ginny Caughey [MVP]]

Do you have to stay on CF 1 and CE 4.1, or do you have some options there?
For example, there are things you can do with SQL Compact like using
SqlCeResultSet and TableDirect that can provide good performance even in low
memory situations, but it requires at least CF 2. I agree that 1400 records
isn't a lot. I have a WM5 app that that is able to find data from a SQL
Compact table with 65000 rows using an indexed key very fast.

Following up on Chris's suggestion, are you using a WHERE clause to get only
the data you need? If so, then an index would certainly make a difference.
Do you really want to retrieve all 1400 rows every time you execute the
query? If so, what do you do with them?

--
Ginny Caughey
Device Application Development MVP

www.wasteworks.com
Scalehouse and Billing Software for Waste Management

I'd start by simply adding an index to the table or tables you're
querying.
SQLCE isn't the fastest thing out there, but it can certainly do better
than
5 seconds on a 1400 record table .

Also, if it's not your app you're not going to be able to just swap out
the
data engine. That requires a code change.

--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Giving back to the embedded communityhttp://community.OpenNETCF.com








- Alýntýyý göster -

code changing is not important for me, because i am re-engineering
this project may i will re-write it.
index wouldn't make me faster because i don't use any criteria just
"select a,b,c from table;"

do you any offer for choosing fastest database technology?