Hiren Parekh
New Member
We need to create a dashboard to display specific client data from a database that has around 70 million records. The data cannot be grouped.
The method of using a SQL connection is very slow. The end user has to search for the client using the name and DOB from a list that is visible when a search is done.
Is there a way to only bring in records via the SQL query for a particular client based on the end user input that is faster than going thru the whole SQL database?
Please advise.
Thank you.
The method of using a SQL connection is very slow. The end user has to search for the client using the name and DOB from a list that is visible when a search is done.
Is there a way to only bring in records via the SQL query for a particular client based on the end user input that is faster than going thru the whole SQL database?
Please advise.
Thank you.