Re: TADO vs. TQuery

Maurice is absolutely right. Most of your speed will depend on your
database, query plan, not selecting unused columns, indexes, size of result
set, cursor location, bandwidth, data types, ..... etc. All that is mostly
on the database and in your coding techniques.. A bad database design and a
bad query will kill both ADO or any other access method.


.

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: SQL Mobile 2005 Performance Monitoring tool
    ... Probably not feasible in your case but SQLite is very fast and very simple to see the query plan. ... for me to tune my database queries? ...
    (microsoft.public.pocketpc.developer)
  • 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: Bound or unbound
    ... The .AddNew Method of the Binding Context will add a new record to the DB ... "Maurice" wrote in message ... > Dear Cor, ... how do I add a new record to the database AFTER the user ...
    (microsoft.public.dotnet.general)