Issue 16072 - Form searches very slow
Summary: Form searches very slow
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@dba
URL: http://dba.openoffice.org/servlets/Re...
Keywords:
: 16073 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-06-25 14:34 UTC by Unknown
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-06-25 14:34:34 UTC 
Making a (either fulltext or simple) search over a datasource is very slow when
done in a form. Although there are certain differences (a search in MySQL is of
course somewhat faster than in a DBase data source) the behaviour does not
change with different types of datasources.
To compare OO data-base-access with the most likely competitor, MS Access, a
search done through a form was ca. 60 times faster in Access.
This seems to result from OO loading every entry of the data source in the form
and then searching it instead of querying the data source directly and only give
the result in the form.
Comment 1 Unknown 2003-06-25 14:48:30 UTC 
*** Issue 16073 has been marked as a duplicate of this issue. ***
Comment 2 marc.neumann 2003-07-01 13:16:56 UTC 
Hi,

I close this issue, because it's not an issue. See 
http://dba.openoffice.org/servlets/ReadMsg?msgId=735536&listName=users

for the reason.

Bye Marc
Comment 3 marc.neumann 2003-07-01 13:17:10 UTC 
close
Comment 4 hans_werner67 2004-02-02 12:23:51 UTC 
change subcomponent to 'none'