Issue 16073 - Form searches very slow
Summary: Form searches very slow
Status: CLOSED DUPLICATE of issue 16072
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:
Depends on:
Blocks:
 
Reported: 2003-06-25 14:35 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

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-06-25 14:36:45 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:31 UTC
sorry, this double entry was caused by a browser problem...

*** This issue has been marked as a duplicate of 16072 ***
Comment 2 marc.neumann 2003-07-03 09:32:13 UTC
closed
Comment 3 hans_werner67 2004-02-02 12:24:03 UTC
change subcomponent to 'none'