Hi!

I have one table (local or C/S) with thousands of records (string, boolean,
integer, etc...).
I need to get the MAX value of one of the fields.

Which is the best/faster method?

   "select MAX(field) from Table"

   "select field from Table order by field"     and then doing a
"Query.Last"

   "select field from Table order by field DESC"

   "Using a Table, not a Query?"

Which is the better method in Local/Shared mode?
Which is the better method in C/S mode?

Note: "Field" is an INDEXED Integer Field

Thanks!

Santy

At least for me using table with correct index *ALWAYS* be faster than
queries. Doesn't matter if is C/S or not.

Eduardo

Ok...

Do you mean using a "Table.Last" ?

Another opinion?

Thanks!

"Jose Eduardo Helminsky" <contato@hpro.com.br> escribió en el mensaje
news:D0BF938F-0374-4401-8E95-73C7B76F81AB@news.elevatesoft.com...
> Santy
>
> At least for me using table with correct index *ALWAYS* be faster than
> queries. Doesn't matter if is C/S or not.
>
> Eduardo
>

Santy,

<< I have one table (local or C/S) with thousands of records (string,
boolean, integer, etc...).
I need to get the MAX value of one of the fields.

Which is the best/faster method? >>

These two:

"select MAX(field) from Table"

"Using a Table, not a Query?" with a Last call.

--
Tim Young
Elevate Software
www.elevatesoft.com