Method and system for improving performance of an issue management system

A method of improving a response time for queries to a server-side database from a client running on a remote device, comprising the steps of:

• receiving at least one filtering parameter;
• submitting a request to the server-side database, the database including a first entry and a second entry, wherein the first entry includes a database function that makes reference to a value stored in the second entry;
• receiving a response from the server-side database based on the at least one filtering parameter;
• evaluating the database function associated with the first entry to obtain a first entry result;
• creating a partial database on the remote device, the partial database including the first entry the partial database being smaller than the server-side database,
• wherein the step of creating the partial database further includes evaluating the database function at a time of retrieval for the first entry in the server-side database, the database function initially making reference to the second entry in the server-side database, and storing the result of evaluating the database function in the partial database without reference to an entry in the server-side database;
• storing the first entry result in the partial database;
• receiving a database query;
• and
• retrieving results from the partial database based on the database query with a reduced query response time achieved by performing the database query locally, the results including the first entry result.

A system for improving a response time for queries to a server-side database from a client running on a remote device, comprising:

• a processor;
• and
• a non-transitory computer readable medium including instructions executable by the processor to cause the processor to:
• receive at least one filtering parameter;
• submit a request to the server-side database, the request including the at least one filtering parameter;
• receive a response from the server-side database based on the at least one filtering parameter;
• create a partial database on the remote device based on the response from the server-side database, the partial database being smaller than the server-side database,
• wherein the step of creating the partial database further includes evaluating a database function at a time of retrieval for a first entry in the server-side database, the database function initially making reference to a second entry in the server-side database, and storing the result of evaluating the database function in the partial database without reference to an entry in the server-side database;
• receive a database query;
• and
• retrieve results from the partial database based on the database query with a reduced query response time achieved by performing the database query locally, the results including the result of evaluating the database function stored in the partial database.