Re: SQL Mobile 2005 Performance Monitoring tool

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

Probably not feasible in your case but SQLite is very fast and very simple to see the query plan.
There is a very good, free .net wrapper.

RBS


"Johnson" <Johnson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:8FA3033B-5A58-435C-903C-C292ADD6F9A2@xxxxxxxxxxxxxxxx
Hi,

anyone knows any SQL Mobile 2005 Database Performacne Monitoring tool out in
the market that can allow me to view execution plan of my queries in order
for me to tune my database queries?

Please advise urgently as my PDA application is running real slow when
performing select/insert/update on a huge database table of more than 10000
records.

Thanks

--
Johnson

.

Relevant Pages

  • Re: Database Information Storage
    ... One other thing that may help, is to compact your database. ... Opening a query in design view and changing it, saving the change, and then ... reexamine the query plan and make optimizations to the query plan. ... > as the table gets biger and biger. ...
    (microsoft.public.access.queries)
  • Re: Query Optimization
    ... If you want to work with the query plan in JET, ... After I compact the database, I would expect the queries to be ... Initially, qryFast is fast and qrySlow is slow, but after you compact ...
    (microsoft.public.access.queries)
  • Re: PreparedStatement problem
    ... when we run the java code ....the SQL query go to the DB ... ...then DB makes a query plan for it via its DB compiler and keep ... the database is quite separate from the ... The key here is JDBC. ...
    (comp.lang.java.programmer)
  • Re: TADO vs. TQuery
    ... Maurice is absolutely right. ... database, query plan, not selecting unused columns, indexes, size of result ... on the database and in your coding techniques.. ...
    (borland.public.delphi.database.ado)