Can someone explain to me how the data arrives at my front end workstation when i'm querying data from a back end table?
I have a backend table with +20k records in it and when my frontend query is asking for one specific record it lags over the network before displaying the data.
The frontend query is only asking for 1 record with 3 fields of data . The backend table has approx 50 fields of data per record.
It seems like the front end query is pulling all the fields for all the 20k records onto the frontend dbase and then the front end query is sorting through this data to display the 3 fields of data for the 1 specific record i'm asking for? Is this how the queries work?
If so how would i tell the front end to only pull the 1 record through the network from the backend to the front end (without having all this unnecessary traffic over the network - which is causing the slow speed?
Thanks in advance