--Original Message-----
From: Barnea, Doron [mailto:barned@e...]
Sent: 28 June 2000 11:16
To: 'support@w...'

Hi
I've purchased your "Professional ADO 2.5 Programming" Book.

Definitely a good and serious book. I enjoyed very much reading about the
Data Access History and evolution. 

I'm now trying to migrate DAO to ADO in VB6 . The reason for that is that 
I
get poor performance time. The DB I use is Jet 4.0 since it's a stand 
alone
program that will access a local DB . 

I wasn't familiar with ADO at all up to reading your book. It's seems like
it has a good potential to make things work faster. Especially using the
Cached Rows feature through the Cursor Service.

However, There are curtain limitations that make my life harder than I
suspected.

I was hoping of loading the DB to the local memory using the Cursor 
Service
and start dealing with it there. I don't need synchronization with the DB 
so
I figured using the disconnected recordset option as well.

Just a small brief of my application : About 300,000 records in the MDB
file. It does processing of summing and counting while updating on the
tables or part of them ( which gave me an idea to use the filter option ) 
.

Anyway , I started converting the application just to compare the
performance issue.

My first problem was that there is no equivalent in the Cursor Service ( 
you
didn't mention it ) for updating a field in one command. Something
equivalent to "UPDATE customers SET orderid = 666" . If there is how can I
do it ?, must I loop through all the records and update each one of them ?

The second problem is that annoying limit of using AND and OR in the 
filter
option . Why did they limit that ? 

The third problem is that I cannot ( I don't remember reading about that )
use SQL functions like SUM . I guess it's like the first problem . The
general question about those two problems should be " Can I perform an
EXECUTE command on a cached row dataset ? " . How ?

Thanks.

Doron.