Re: access migration to SQL
Originally Posted by Kuhn
the search function does use the (dim rst as DAO.recordset) rst.movefirst command and searching for a certain value.
So, you are searching the Recordset for a certain value. - Bad idea in a client-server-environment. This forces all
the data to be transferred to the client before your search can happen.
In a client-server-environment you should try to let the server do most of the work by using SQL queries to filter down the data first. Only after that you would do additional client side processing on a small sub-set of the data. (If still required at all.)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Last edited by sonic8; 08-14-2018 at 10:53 AM.