Hi,
What would be the most recommended way to go, if fast response times are a concern ?
There is an SQL database with +/- 50 fields.
The max number of records will rarely exceed 500.
But I need to question it in a variety of ways.
Two possibilities:
a) For each question, i need a different combination of fields to be selected and some "WHERE " clause.
Advantage : the "sel as cursor" will contain something closer to what i need, disadvantage, i need many different SQL statements.
b) i simply do "SELECT * from..." no where clause, and i filter out what i need in code.
Advantage: obviously only one call to the database, disadvantage: some more code to write.
I can assess the coding consequences of a) and b), except that i have no idea of the resource impact on the tablet.
Calling an SQL database multiple times might be more punishing than writing a For Next loop to go through all the records every time.
Any thoughts ?
thx,
Paul
What would be the most recommended way to go, if fast response times are a concern ?
There is an SQL database with +/- 50 fields.
The max number of records will rarely exceed 500.
But I need to question it in a variety of ways.
Two possibilities:
a) For each question, i need a different combination of fields to be selected and some "WHERE " clause.
Advantage : the "sel as cursor" will contain something closer to what i need, disadvantage, i need many different SQL statements.
b) i simply do "SELECT * from..." no where clause, and i filter out what i need in code.
Advantage: obviously only one call to the database, disadvantage: some more code to write.
I can assess the coding consequences of a) and b), except that i have no idea of the resource impact on the tablet.
Calling an SQL database multiple times might be more punishing than writing a For Next loop to go through all the records every time.
Any thoughts ?
thx,
Paul