Hi Sue, (You don't say explicitly, so I'll assume that you are using Postgres)
I can't explain why the addition of metadata rows is taking so long - there are a number of factors that could come into play... server getting many / expensive requests, resource contention, postgres needs maintaining (ie. vacuum) or tuning or upgrading, or all three. However, the issue of slow installing (license granting) of items, is quite likely answered in this post: http://sourceforge.net/mailarchive/message.php?msg_name=9efc26fb-749c-4a67-8481-f1a6ce09b...@gmail.com to put it briefly - the item installation takes on some extra work in browse indexing to ensure that general browse lookups are efficient (you only add an item once, users might issue 100s of browse requests a day). The SQL that makes that calculation is written in it's most efficient form. But you still need the database to be configured properly in order for that operation to be executed in an efficient way. If you are using the default work_mem setting, you can easily save 60% of your installation time - and generally improving the efficiency of the database - by increasing it appropriately. Regards, G On 4 February 2010 23:29, Thornton, Susan M. (LARC-B702)[RAYTHEON TECHNICAL SERVICES COMPANY] <[email protected]> wrote: > Hello, > > > > We have been noticing recently that, as our repository grows in size > (we currently have approx. 125,000 Items and adding more each week), our > online submission process is getting slower and slower and slower. It’s > gotten so bad that, even if I’m only trying to add more authors to an Item > by clicking the “Add more” button: > > > > It is taking a really long time (just now it took approximately 20 seconds) > for the application to respond with the subsequent screen: > > > > > > To make things worse, once the customer clicks on the “I grant the license” > button, the application hangs not just for seconds, but for minutes (I saw > one case of 11 minutes recently). Our customers are getting very frustrated > with this. > > > > Has anyone else had this problem or does anyone have an idea of where > DSpace might be getting bogged-down. I looked at the INFO messages in the > dspace.log file and there seems to be a whole lot of “update_item” lines in > there while not much seems to be happening on the screen, but I didn’t look > at the programs in detail. > > > > Any help would certainly be appreciated. > > > > Best regards, > > Sue > > > > *Sue Walker-Thornton* > > *ConITS Contract** > **NASA Langley Research Center** > **Integrated Library Systems Application & Database Administrator* > > *130 Research Drive* > > *Hampton, VA 23666* > > *Office: (757) 224-4074** > **Fax: (757) 224-4001** > **Mobile: (757) 506-9903* > > *Email:** ** **[email protected]* <[email protected]> > > > > > ------------------------------------------------------------------------------ > The Planet: dedicated and managed hosting, cloud storage, colocation > Stay online with enterprise data centers and the best network in the > business > Choose flexible plans and management services without long-term contracts > Personal 24x7 support from experience hosting pros just a phone call away. > http://p.sf.net/sfu/theplanet-com > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech > >
<<image004.jpg>>
<<image003.jpg>>
------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com
_______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
