BUGGER - Bug Report 32 Details

Developer Bug Page



Bug Status: Closed - Resolved
Bug ID:32
Project: Claims_DB
Date Logged: 31/08/2009
Logged By: B Tasker
DetailsQueries based on primary key take longer than necessary on large tables.

Create a flag to notify read_records_claims.sh that the query is for a primary key, and to stop looking after 1st result.

Developer:B Tasker


Developer Notes:Addition of a Table tidying function could also benefit primary key searches




Bug Comments:



Added -primkey option to Queries, and line no queries. Should be passed as 4th argument.

Seperate report will be logged for Table Tidying function

B Tasker 31/08/2009Report Abuse




Issue on Lines 611 and 470 identified during test. fi placed within an EOM line.

Moved to outside of the EOM, function now works correctly

B Tasker 31/08/2009Report Abuse




Some older versions of Grep do not support the -m argument.

To prevent failures, option added to config file to override -primkey arguments.

Front-ends can be written assuming that -primkey can be used, and the configuration of the database itself will make the ultimate decision

B Tasker 31/08/2009Report Abuse




BUGGER is still under Heavy Development, Please Bear with us!

Copyright Ben Tasker 2009
Released under the GNU GPL
See http://benscomputer.no-ip.org/LICENSE

No permission given for Interception of communications by any third party.


"Broken? Have you BUGGERed it?"