Activity

From 05/11/2006 to 06/09/2006

12:39 PM Bug #2434: Profiling of XML Loader's Performance: Typo fixes for the last comment...oops.
(In reply to comment #5)
1) **Change the** SAX parser parse and load per ob... Chad Berkley
12:34 PM Bug #2434: Profiling of XML Loader's Performance: I've been looking at possible ways to speed the loader up even more than we already have for the last 2 days. Basica... Chad Berkley

01:24 PM Bug #2434: Profiling of XML Loader's Performance: I've finished my analysis of the observation insertion part of LoadTreeToDatabase.insertVegbankPackage(). It is stil... Chad Berkley

02:55 PM Bug #2434: Profiling of XML Loader's Performance: Michael pointed out that the accessionCode field in several tables gets hit a lot. Since the field is pretty static,... Chad Berkley
01:44 PM Bug #2434: Profiling of XML Loader's Performance: It seems a lot of time is being spent in the LoadTreeToDatabase.insertTaxonObservations() method. For a run of the s... Chad Berkley

02:23 PM Bug #2434: Profiling of XML Loader's Performance: I inserted a timer into the loading code. Below are the results for a very small xml file. A 0 in the timer means i... Chad Berkley
02:21 PM Bug #2283: Email to user does NOT work after load: using Hyperion!: changed to mail.nceas.ucsb.edu. the property can be changed in build.properties if installed outside nceas. Chad Berkley
12:59 PM Bug #2453: Empty DB created, add necessary population + verify: Also need a DROP script so we don't have to use a dropdb to start with a fresh schema. Chad Berkley
12:55 PM Bug #2453 (Resolved): Empty DB created, add necessary population + verify: Currenty, the sql scripts, both generated and static, do not properly build the database. It is currently impossible... Chad Berkley
09:48 AM Bug #2442: Create a "request new AccessionCode" function for VegBranch in VegBank: http://aldo.nceas.ucsb.edu/vegbank/views/getNewRequestID.jsp?tablename=observation&recordcount=4
creates 4 new obser... Michael Lee
09:39 AM Bug #2442: Create a "request new AccessionCode" function for VegBranch in VegBank: database.accession.key.preassign=VBAldoPre
is also added to build.properties in the /vegbank/ directory. Michael Lee

10:37 AM Bug #2402: Strategy to update denormalized data, cache, pages: We might be able to use triggers to handle all the denorms. Then it's out of sight and out of mind. Update anything... Michael Lee

12:02 PM Bug #2401: Switch default mapping from Yahoo to Google: fixed in datacart view Michael Lee

06:18 PM Bug #2423: Upgrade to v2 for google maps on VegBank site: not too difficult. Now adding more mapping will go through version 2 and we won't have to do this but once. Michael Lee
11:58 AM Bug #2444 (Resolved): user passwords are stored in clear text in the database: User's passwords stored in the usr.password table/column are stored in clear text. This allows a system administrato... Chad Berkley

09:54 AM Bug #2424: new feature: Create "find plots by area" using google maps: exactly the same
*** This bug has been marked as a duplicate of 2404 *** Michael Lee
09:54 AM Bug #2404: Evaluate: Let users define bounding box with Google Maps, then show plots in that area: *** Bug 2424 has been marked as a duplicate of this bug. *** Michael Lee
09:46 AM Bug #2423: Upgrade to v2 for google maps on VegBank site: also useful: http://www.google.com/apis/maps/documentation/reference.html Michael Lee

12:23 PM Bug #2442: Create a "request new AccessionCode" function for VegBranch in VegBank: this XML was successfully imported:
http://www.unc.edu/~mikelee/Misc/testImportXML2.xml Michael Lee
11:45 AM Bug #2442: Create a "request new AccessionCode" function for VegBranch in VegBank: Confirm for newly issues confirmation codes should be some random string, as we won't know "diddley" about the actual... Michael Lee
11:38 AM Bug #2442: Create a "request new AccessionCode" function for VegBranch in VegBank: I'd imagine this working on the VegBank side as a new table called "issuedAccessionCode"
A client would be able to r... Michael Lee
11:32 AM Bug #2442 (Resolved): Create a "request new AccessionCode" function for VegBranch in VegBank: This will allow users to request GUIDs from VegBank.org from ANYWHERE. This makes bug 1859 and bug 1828 unneeded, i... Michael Lee

08:35 AM Bug #2436 (New): Evaluate: Map plots with one click from plot-result-set: I was interested in poissible deeplinks to maps of plots with taxa. Can this be done? I
do a search for Quercus al... Michael Lee

Also available in: Atom

VegBank