Project

General

Profile

Actions

Bug #1121

closed

Large plant queries cause Out of Memory error

Added by Gabriel Farrell over 20 years ago. Updated about 19 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
misc
Target version:
Start date:
07/24/2003
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
1121

Description

An unrefined plant query that results in the system tring to large numbers of
plant is both slow and memory hungry ( even resulting in the jvm consuming all
its memory resources ).

This could be solved in a number of ways:

1. Have a google type interface thus limiting the display to some limited number
of plants ( 10, 50, 100?).
2. Move away from the xml/xsl pathway, populating a jsp or creating html on the
fly from JDBC resultset ( or some simple java object like PlantsSummary).
3. Both.

Actions #1

Updated by Michael Lee over 20 years ago

not sure why this bug is mine.

Actions #2

Updated by Gabriel Farrell almost 20 years ago

This is less severe now that users cannot search using the dreaded empty
string ... which returns all plants. ( they could still do this with
plantname="%" query unfortunately but then they are being malicious ).

So we still need the pagination to really clear this up.

I suggest using the postgresql offset limit functions to achieve this.

Actions #3

Updated by Michael Lee over 19 years ago

this is an old bug, now solved by the perPage style views

Actions #4

Updated by Michael Lee about 19 years ago

changed from components that are to be deleted to "misc" so that bugs don't get
deleted with component. Sorry for all the email.

Actions #5

Updated by Redmine Admin about 11 years ago

Original Bugzilla ID was 1121

Actions

Also available in: Atom PDF