Re: SQL Mobile 2005 better performance ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Marico,

You need SQL 2005 Management Studio, which comes with SQL 2005 Developer.
You connect to your SQL Mobile database, then run a query.

For example, you could test using the Northwind.sdf file that is installed
with VS 2005 at c:\Program Files\Microsoft Visual Studio
8\SmartDevices\SDK\SQL Server\Mobile\v3.0. Connect to this database, then in
the Query menu, select Include Actual Execution Plan. If you run a query
like SELECT * FROM customers, you will see Query 1: Query cost (relative to
the batch): 100% and it will show you that the execution engine is doing a
table scan.

If you do a slightly more complex query like SELECT * FROM customers WHERE
[country] = 'USA', you will see that the filter cost is 74% and the table
scan is now 26%. This gives you the ability to see where the execution
engine is spending its time and whether, for example, an index over Country
would be useful.

Similarly, you could execute a query like SELECT * FROM Customers WHERE
[region] = 'OR', and you'd see that instead of a table scan, an index seek
is performed using the customers.Region index. You can even hover over each
phase illustrated in the execution plan and see a lot of details about the
operation such as estimated I/O cost, estimated CPU cost, etc.

--
Ginny Caughey
..NET Compact Framework MVP


"marciocamurati" <marcio.camurati@xxxxxxxxx> wrote in message
news:1129048494.810041.223890@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Ginny,
>
> Thanx for your sugestion, now I am reading and wathing all material
> about Sql Server Mobile that I found in the Microsoft website and
> another locations, for take a decision about spend time with Sql Ce or
> go to another database, and all answers that I get here help me a lot.
> I have another doubt not about performance, where is this Show Plan
> that you talk in the Mobile 2005 ? I didn't found it.
>
> Thanx
>
> Marcio Camurati
>
> Ginny Caughey [MVP] escreveu:
>
>> Marcio,
>>
>> I think if you switch to SQL Mobile and also switch from DataSet to
>> SqlCeResultSet you will see significant performance. You can also tweak
>> performance by using SQL Server Management Console 's Query Analyzer and
>> Show Plan to get an idea where bottlenecks might be and how you could
>> improve queries with new indexes, etc.
>>
>> --
>> Ginny Caughey
>> .NET Compact Framework MVP
>>
>>
>> "marciocamurati" <marcio.camurati@xxxxxxxxx> wrote in message
>> news:1129033230.363161.46870@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> > Ok, I understand but I need in my application fast response by the
>> > database because is a mobile application for Tourism Business, and my
>> > doubt now is SQL Mobile 2005 can give me this speed in my application
>> > or in this case is better use another database, what you suggest for
>> > me? Spend time with SQL Server Mobile 2005 or search another solution,
>> > for example Oracle Lite ?
>> >
>> > Thanx
>> >
>> > Marcio Camurati
>> >
>> > Darren Shaffer escreveu:
>> >
>> >> that's hardly a comparison. SQLMobile has a new storage engine,
>> >> a rewritten query processor and many other optimizations to improve
>> >> performance. a simple SELECT statement is unlikely to result in
>> >> a very different query execution plan between SQL CE and
>> >> SQLMobile simply because it is trivial.
>> >>
>> >> where you'll see the real performance improvements is in complex
>> >> queries, merge replication, and databinding with the SqlCeResultSet.
>> >>
>> >> --
>> >> Darren Shaffer
>> >> .NET Compact Framework MVP
>> >> Principal Architect
>> >> Connected Innovation
>> >> www.connectedinnovation.com
>> >>
>> >>
>> >> "marciocamurati" <marcio.camurati@xxxxxxxxx> wrote in message
>> >> news:1128995955.070045.68410@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> >> > Hi Ginny,
>> >> >
>> >> > I make a test using se Query Analiser, one PDA with Query Analiser
>> >> > v2.0
>> >> > and another with Qury Analiser v3.0, right ? At this tow PDA I put
>> >> > the
>> >> > same SQL Data Base, (convert to SQL Mobile 2005), and make a simple
>> >> > query in a table that have (3000 rows and 5 columns):
>> >> >
>> >> > Select * FROM tb_people
>> >> >
>> >> > And the two versions give the result in 12 seconds.
>> >> >
>> >
>


.

Relevant Pages

  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: complex filter and calculations in access
    ... switch to SQL view. ... query by switching to datasheet view, ... of your database using the from address in this post. ... pre-op infections yes/no ...
    (microsoft.public.access.queries)
  • Re: A little more meat this week
    ... implementation with a query processor capable of returning a result set ... then we can call it a result bag (SQL ... I'm looking at the data model and not database tools at this ... for a s/w developer and a s/w developer simplifies for the end user). ...
    (comp.databases.pick)
  • Re: complex filter and calculations in access
    ... when using a subquery on the same table as the main query, ... switch to SQL view. ... of your database using the from address in this post. ...
    (microsoft.public.access.queries)
  • Re: A little more meat this week
    ... said data includes lists." ... implementation with a query processor capable of returning a result set ... then we can call it a result bag (SQL ... I'm looking at the data model and not database tools at this ...
    (comp.databases.pick)