Opened 9 years ago

Closed 9 years ago

#255 closed enhancement (fixed)

Extend SQL procedure output

Reported by: gegorbet Owned by: dzollars
Priority: normal Milestone: future
Component: ultrascan3 Version:
Keywords: review Cc:

Description

As Dan suggested, database scans could be made much more efficient - especially across networks - by increasing the information returned by the APIs that return arrays, so multiple queries are not necessary.

My study of us_manage_data and us_loadable_noise suggests the following additions.

  • all_rawDataIDs - add: rawGUID, comment, experimentGUID
  • all_editDataIDs - add: editGUID
  • get_model_desc - add: cksum, size, date, monteCarlo (0|1), requestGUID
  • get_noise_desc - add: modelGUID, cksum, size, date

Change History (2)

comment:1 Changed 9 years ago by dzollars

  • Keywords review added
  • Status changed from new to assigned

Changes have been made to the stored procedures. Wiki is updated with new info. All instances updated.

comment:2 Changed 9 years ago by gegorbet

  • Resolution set to fixed
  • Status changed from assigned to closed

I have coded changes that take advantage of the additional fields added. I can verify that the changed procedures work. I can also report that these changes caused us_data_loader, us_loadable_noise, and us_manage_data to do their DB scans at a 5 to 6 times faster rate.

There are some additional changes that would be useful, but they involve adding to the content of tables; and these change requests are best documented in a new ticket.

I am marking this ticket fixed.

Note: See TracTickets for help on using tickets.