Client Side Processing

[ClulessChris]

When sending an SQL to an Access DB on a network server is the whole table returned in the record set and the unneeded fields discarded by the Client, or are only the requested fields returned?

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[ClulessChris]

To elaborate; If Table1 has Fields 1 - 5 and my
SQL = SELECT Field1, Field2 FROM Table1
are fields 3-4 'pulled' from the database only to be discarded by the client?

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[Gruuuu]

This is only an educated guess, because I'm not exactly sure how Access does it, if differently.

But...

RDBMSs just don't work that way. A client only needs to be able to send the query string to the correct location for the database to return results. All processing is done by the database and results are sent back to the client.

 

[ClulessChris]

Guuuu. Thanks for your input. MS Access doesn't do server side processing ( as far as I'm aware) and so I'm just trying find out what is sent back.

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[xlbo]

as far as I know, for all databases, the query string is sent to the database. The database processes the request and sends only the relevant data back to the requester

Any processing is done on the physical server / computer that the access db resides on

To confirm, only requested fields are returned.

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[strongm]

>Any processing is done on the physical server / computer that the access db resides on

Not quite correct when talking about an Access datastore. Whilst the datastore may be remote, the processing is ALL local.

The Jet database engine does not run remotely; it runs on the client hardware. Therefore the entire dataset has to be pulled over to the client, where the engine runs the query and returns (filtered) data to the requester

 

[ClulessChris]

strongm,
Thnaks for your input. "the entire dataset" is that just the relevent tables or everything in that mdb?

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[xlbo]

strongm - thanks - didn't know that :~/

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question