Displaying info before commit

Discuss the database features

Displaying info before commit

Postby dreamquartz » Wed Jan 24, 2018 7:02 pm

Hi All,
Do not know what a good subject title should be for this one, but can describe what I am looking for.

The DataBase I am responsible for is growing fast, and that is a good thing. The Client is very happy.

There is, however, something happening that is slowing down entry of information.
When Personal and Company Data is entered, including Address Info, the User has the opportunity to verify the Address data by a form "refresh" .
The Address Info is then being read from a View, for consistency.

This is where the problem lays. Every time the refresh button is being pushed, the Query behind the View has to re-create the View for it to be shown for that particular Address. Now that there are more than 10,000 Addresses stored, it is taking longer and longer and longer......

What I would like to be able to accomplish is to create a View for that specific Address only for use of verification, and then later, whenever needed, the Query involved can do its thing, so to speak.

Can someone provide me with some guidance, to help me in the right direction?

Thanks in advance,

LO 5.x and OO 4.x on Windows 7 PRO & Ubuntu 16.04 LTS.
Posts: 620
Joined: Mon May 30, 2011 4:02 am

Return to Base

Who is online

Users browsing this forum: No registered users and 4 guests