For finding a record in a table, is it fast to use direct table access or a query?  Is there a general set of rules when a query should be used over a table and vice versa?

Thanks

Scott,

<< For finding a record in a table, is it fast to use direct table access or
a query?  Is there a general set of rules when a query should be used over a
table and vice versa? >>

It really depends upon your needs, but the fastest way is TEDBTable.FindKey,
followed by TEDBTable.Locate (using an index), TEDBTable.Filter, TEDBQuery
(sensitive result set), and finally TEDBQuery (insensitive result set).

--
Tim Young
Elevate Software
www.elevatesoft.com

So for a simple query like "Select * from Customers where ID = '4'" a table with an index is the way to go, but for a complexe data result where multiple tables are joined
the query is the way tp go?

Thanks

Scott


Table.FindKey is probably going to be fastest. But, you have to think local vs LAN vs WAN and fileserver vs clientserver. Or to put it another way - it depends


Roy Lambert

OK  - lol - so in the Client - Server model, the query would be faster then the
direct table access for a "Select * from Customers" type of data access?

Scott,

<< So for a simple query like "Select * from Customers where ID = '4'" a
table with an index is the way to go, but for a complexe data result where
multiple tables are joined the query is the way tp go? >>

Well, the differences are very small, so usually we recommend going with
what you feel most comfortable with and works best for your application.
In other words, if you prefer SQL, then use SQL always.

--
Tim Young
Elevate Software
www.elevatesoft.com

Scott,

<< OK  - lol - so in the Client - Server model, the query would be faster
then the direct table access for a "Select * from Customers" type of data
access? >>

Pay no attention to the Scotsman.

Actually, with EDB C/S access the FindKey would still be faster.   But,
again, we're talking very small differences.   The important thing to
remember is that a:

SELECT * FROM MyTable

type of query with the RequestSensitive property set to True is exactly the
same as basically just opening up the table.   Likewise a:

SELECT * FROM MyTable WHERE MyColumn=1

type of query with the RequestSensitive property set to True is exactly the
same as basically just opening up the table and applying a filter to it of
'MyColumn=1';

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks - this clarified things.

Tim


>Pay no attention to the Scotsman.

Yorkshireman living in Scotland please!

Roy Lambert

Tim Young [Elevate Software] wrote:

> Scott,
>
> << For finding a record in a table, is it fast to use direct table access or
> a query?  Is there a general set of rules when a query should be used over a
> table and vice versa? >>
>
> It really depends upon your needs, but the fastest way is TEDBTable.FindKey,
> followed by TEDBTable.Locate (using an index), TEDBTable.Filter, TEDBQuery
> (sensitive result set), and finally TEDBQuery (insensitive result set).
>

Tim,
   What, no ranges in EDB?

Dave