For speedy database access, I only create recordsets that
contain the minimum amount of data needed. So for example,
if I need a record for John X. Smith, I don't retrieve all
20,000 records on my table and then search for John X
within that recordset. Instead I use a SQL Select statement
with a WHERE clause to get just the fields I need and just
the record for this person.
Select address1, address2, city, state, zip, phone from
my_table where firstname = 'John' and middlelinit = 'X' and
lastname = 'Smith'
> --------------3046B76C5A2C2A1986616225
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> I'm moving from DAO to SS7 and have a BIG problem.
> Generally:
> I need to open a recordset and quickly search for a
> row in it so I can
> later use .move from that row.
> Example:
> Customer table with Name_Last, Name_First,
> Name_Initial and an index
> using those fields.
> I want to move the cursor to the first row containing
> Smith, John Q.
> then move forward or backward as needed.
> The Problem:
> Opens using client side cursor takes ~ 20 sec (15,000
> rows) but .find is
> quick
> [I use a sequence of .find's since MS in their
> infinite wisdom only
> allow searching by one criteria(field) at a time]
> Opens using server side cursor are fast but then the
> .find takes ~ 20
> sec
> --------------3046B76C5A2C2A1986616225
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> <!doctype html public "-//w3c//dtd html 4.0
> transitional//en">
> <html>
> I'm moving from DAO to SS7 and have a BIG problem.
> <br><font color="#000066"><u>Generally</u>:</font>
> <br> I need to open a recordset and quickly
> search for a row in it
> so I can later use .move from that row.
> <br><font color="#000066"><u>Example</u>:</font>
> <br>Customer table with Name_Last, Name_First,
> Name_Initial and an index
> using those fields.
> <br>I want to move the cursor to the first row
> containing Smith, John Q.
> then move forward or backward as needed.
> <br><font color="#000066"><u>The Problem</u>:</font>
> <br>Opens using client side cursor takes ~ 20 sec
> (15,000 rows) but .find
> is quick
> <br>[I use a sequence of .find's since MS in their
> infinite wisdom only
> allow searching by one criteria(field) at a time]
> <br>Opens using server side cursor are fast but then
> the .find takes ~
> 20 sec</html>
> --------------3046B76C5A2C2A1986616225--
* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful