Help about choosing efficient database technology

tenkyu · Joined: 19 Feb 2008 Posts: 2

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.

Archived from group: microsoft>public>dotnet>framework>compactframework

user · Joined: 08 Aug 2007 Posts: 286

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" wrote in message @u10g2000prn.googlegroups.com...
> 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.

tenkyu · Joined: 19 Feb 2008 Posts: 2

On 19 Þubat, 16:42, "" wrote:
> 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
>
> "tenkyu" wrote in message
>
> @u10g2000prn.googlegroups.com...
>
>
>
> > 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 newdatabasecalled SQLite, but i can't use it on the win
> > CE, can anybody help me about this topic.
>
> > Any offers about choosing bestdatabase(SQLite, SQLCE vice versa), if
> > you offer different from SQLCE could you send me a sample.- Alýntýyý gizle -
>
> - 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] · Joined: 08 Aug 2007 Posts: 58

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

"tenkyu" wrote in message @s12g2000prg.googlegroups.com...
On 19 Þubat, 16:42, "" wrote:
> 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
>
> "tenkyu" wrote in message
>
> @u10g2000prn.googlegroups.com...
>
>
>
> > 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 newdatabasecalled SQLite, but i can't use it on the win
> > CE, can anybody help me about this topic.
>
> > Any offers about choosing bestdatabase(SQLite, SQLCE vice versa), if
> > you offer different from SQLCE could you send me a sample.- Alýntýyý
> > gizle -
>
> - 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?

SQLCE Encrypt Database problem - database creates but doesn' Hi all, I have been having a heck of a time getting my sqlce database to encrypt. Here's the create database string I am using: Dim SQLEngine As SQLEngine = New

Pocket PC to remote database Hi First of all, I am a complete newbie to .net. I am wondering what would be the best way for a pocket pc to get info from a office win2k server machine which is behind ISA server? Assuming that both Pocket PC PDA and the office machine are somehow conne

WSE 2.0 Transition from Preview to Supported Technology? Any notion on when WSE 2.0 might transition like 1.0 did from a 'preview' technology to a supported one? Are we talking months, quarters, or next years release of Visual Studio .NET? Thanks

Efficient Memory use in GDI+ In terms of memory used, would it be more efficient to store just a Color variable and then create a new Brush/Pen each time a paint is required, or store a Brush/Pen variable for re-use. All examples + real world code uses the "store Color and create Bru

More efficient way to get/set field values? Hi folks, Lets say that I have a small class with three private fields called A, B and C, all can be different basic types, no object references. Given an instance of this class, what is the most efficient way for another class to set/get values to all th