[Solved] Displaying info before commit

Discuss the database features

[Solved] 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,

04/16/2018; update: closed this question and opened a new one, rephrasing-re-defining the issue
Last edited by dreamquartz on Mon Apr 16, 2018 11:52 pm, edited 1 time in total.
LO 5.x and OO 4.x on Windows 7 PRO & Ubuntu 16.04 LTS.
Posts: 633
Joined: Mon May 30, 2011 4:02 am

Re: Displaying info before commit

Postby mgroenescheij » Sat Mar 24, 2018 8:02 am

I don't know your database but a view on 10.000 records should be fast enough:
IF you haven't the embedded database from OpenOffice
AND IF you have your indexes correct
AND IF you use filters to limit the search
AOO 4.1.3 on MS Windows 10
Please add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.
Posts: 297
Joined: Thu Apr 23, 2009 10:19 pm
Location: Sydney Australia

Return to Base

Who is online

Users browsing this forum: No registered users and 5 guests