I do not understand the following:
Query1 links many tables together and will show all the records
Query2 is a simple select query of query1 and only shows records related to a specific part
Query2 always runs faster (by a couple of seconds)than Query1. Why?
All the tables are in databases on the network file server. Surely the query is being executed on my local machine, therefore all the data will need to be brought down the network processed and then displayed. Therefore query2 should be slower than query1. Obviously there is a gap in my understanding.
Also if I have a mainform and a subform, when the subform loads how much data is dragged over the network? Are the enitre data sets pulled over or subsets? Does the subform only pull data over relating to the mainform, or does it pull over the entire data source.
Basically the network is slowing down my application to an unacceptabel level and I want to know how to tweak the database to speed things up. Any ideas?
Thanks in advance
Query1 links many tables together and will show all the records
Query2 is a simple select query of query1 and only shows records related to a specific part
Query2 always runs faster (by a couple of seconds)than Query1. Why?
All the tables are in databases on the network file server. Surely the query is being executed on my local machine, therefore all the data will need to be brought down the network processed and then displayed. Therefore query2 should be slower than query1. Obviously there is a gap in my understanding.
Also if I have a mainform and a subform, when the subform loads how much data is dragged over the network? Are the enitre data sets pulled over or subsets? Does the subform only pull data over relating to the mainform, or does it pull over the entire data source.
Basically the network is slowing down my application to an unacceptabel level and I want to know how to tweak the database to speed things up. Any ideas?
Thanks in advance