Re: [dspace-tech] Slow performance Dspace 6.2

[Bill Tantzen]

>From my control panel, while my top-level community is loading simultaneously:

Runtime statistics

Available processors: 8
Maximum memory: 16247 MiB
Allocated memory: 16247 MiB
Used memory: 4030 MiB
Free memory: 12216 MiB

It appears that I have plenty of available memory...
Bill

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] Slow performance Dspace 6.2

[Bill T]

Thanks Hardy!

I'm on tomcat 8.5 already, and my startup options are pretty simple:

CATALINA_OPTS="$CATALINA_OPTS -Djava.awt.headless=true
  -Djava.library.path=/usr/local/tomcat-native.lib
  -Dfile.encoding=UTF-8
  -Xms16384m -Xmx16384m
  -Dsolr.autoSoftCommit.maxTime=12 -Dsolr.autoCommit.maxTime=480"

That's half my available RAM, and this is a dedicated machine.  Nothing 
else is running on it (well, except postgresql).  These settings served me 
very well when running DSpace 5, but if you have any other suggestions I 
would love to try them out!

Cheers!
Bill

On Thursday, January 25, 2018 at 12:48:24 PM UTC-6, Hardy Pottinger wrote:

> Hi, there is a wiki page for performance tuning DSpace, you might check it 
> out:
>
> https://wiki.duraspace.org/display/DSDOC3x/Performance+Tuning+DSpace
>
> Alan's right, mostly it boils down to tuning your Tomcat memory settings. 
> Note that this advice only aplies to Tomcat 7 and earlier. During boot-up, 
> Tomcat 8 will explain to you patiently that the old heap settings will be 
> ignored every time you try to set them. So, a potentially easier thing to 
> do would be to move to Tomcat 8, as it will automatically better utilize 
> the memory it has available to to it.
>
> --Hardy
>
>
> On Thu, Sep 14, 2017 at 1:28 AM, Alan Orth  > wrote:
>
>> Hello,
>>
>> Your server should have enough power to run DSpace well. Is there 
>> anything else running on the server? How much of the machine's RAM is 
>> dedicated to the Java JVM heap? You can look in the "Java Information" 
>> section of the control panel when logged into DSpace as an administrator. 
>> Also, is your DSpace a clean installation or is there a lot of content 
>> submitted in it?
>>
>> Regards,
>>
>> On Wed, Sep 13, 2017 at 7:37 PM christian criollo > > wrote:
>>
>>>
>>> Hi Alan
>>>
>>> this is my configuration
>>>
>>> - Operating system version  R/  SUSE Linux Enterprise Server 11 (x86_64)
>>> - PostgreSQL version R/ the database is Oracle Database 11g Release 
>>> 11.2.0.3.0 - 64bit
>>> - Java version R/ java version "1.7.0_45"
>>> - Tomcat version  R/ 7.0.50
>>> - Hardware specifications of your server, like RAM and CPU R/ *three 
>>> proccesors* Intel(R) Xeon(R) CPU E5-2690 v4 @ 2.60GHz  *RAM * 5994588 kB
>>>
>>> I hope htis help
>>>
>>>
>>>
>>>
>>> El miércoles, 13 de septiembre de 2017, 7:43:56 (UTC-5), Alan Orth 
>>> escribió:
>>>
 Hello, Christian.

 You need to give us more information before we would be able to help 
 you. For example:

 - Operating system version
 - PostgreSQL version
 - Java version
 - Tomcat version
 - Hardware specifications of your server, like RAM and CPU

 Regards,

 On Tue, Sep 12, 2017 at 6:02 PM christian criollo  
 wrote:

>>>  Hi all
>
> Recently I installed Dspace 6.2 when I give click in a community, 
> collection or item it takes too long to respond normally it should be a 
> few 
> secondswhat t could be happenning ?
>
>  thanks for the help
>
> -- 
> You received this message because you are subscribed to the Google 
> Groups "DSpace Technical Support" group.
>
 To unsubscribe from this group and stop receiving emails from it, send 
> an email to dspace-tech...@googlegroups.com.
> To post to this group, send email to dspac...@googlegroups.com.


> Visit this group at https://groups.google.com/group/dspace-tech.
> For more options, visit https://groups.google.com/d/optout.
>
 -- 

 Alan Orth
 alan...@gmail.com

>>>
 https://picturingjordan.com
 https://englishbulgaria.net
 https://mjanja.ch

>>> -- 
>>> You received this message because you are subscribed to the Google 
>>> Groups "DSpace Technical Support" group.
>>> To unsubscribe from this group and stop receiving emails from it, send 
>>> an email to dspace-tech...@googlegroups.com .
>>> To post to this group, send email to dspac...@googlegroups.com 
>>> .
>>> Visit this group at https://groups.google.com/group/dspace-tech.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>> -- 
>>
>> Alan Orth
>> alan...@gmail.com 
>> https://picturingjordan.com
>> https://englishbulgaria.net
>> https://mjanja.ch
>>
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "DSpace Technical Support" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to dspace-tech...@googlegroups.com .
>> To post to this group, send email to dspac...@googlegroups.com 
>> .
>> Visit this group at https://groups.google.com/group/dspace-tech.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 

Re: [dspace-tech] Database error when trying to edit epersons (oracle - ORA-00932: inconsistent datatypes: expected -

[Donald Bynum]

I copied the EPerson.java to 
dspace\modules\additions\src\main\java\org\dspace\eperson (I had ti create 
the additions folder) and rebuilt.  Still not good.  How can I be sure that 
the new java class exists?  meaning, where can I look to make sure that the 
newly compiled class is in place?  I am going to try one other thing.  But 
would appreciate any further guidance you can give me.

-Don

On Wednesday, January 24, 2018 at 5:29:44 AM UTC-5, Tom Desair (Atmire) 
wrote:

> Hi Francis,
>
> That's good news! Thanks for testing and your feedback. I hope that this 
> workaround then also works for Don. 
>
> Best regards,
> Tom
>  
> [image: logo] Tom Desair
> 250-B Suite 3A, Lucius Gordon Drive, West Henrietta, NY 14586
> Gaston Geenslaan 14, Leuven 3001, Belgium
> www.atmire.com 
> 
>
> On Wednesday, January 24, 2018 at 11:22:40 AM UTC+1, Francis Brouns wrote:
>>
>> Dear Tom,
>>
>> this workaround seems to work by changing m.text_value in line 502 and 
>> line 510 in EPerson.java for Dspace release 5.6. The error no longer occurs 
>> when selecting epersons or trying to add epersons to a group.
>>
>> case LANGUAGE:
>> s = "m.text_value";
>> t = "language";
>> break;
>>
>>
>> default:
>> s = "m.text_value";
>> t = "lastname";
>>
>>
>> 2018-01-24 11:14:49,448 DEBUG org.dspace.storage.rdbms.DatabaseManager @ 
>> Running query "SELECT * FROM eperson e LEFT JOIN metadatavalue m on 
>> (m.resource_id = e.eperson_id and m.resource_type_id = ? and 
>> m.metadata_field_id = ?) ORDER BY dbms_lob.substr(m.text_value,0,4000)"  
>> with parameters: 7,125
>>
>> I'll try this in  release 5.8 as well and see if we can proceed with the 
>> upgrade.
>>
>> Thanks for now.
>> Francis Brouns
>> Open Universiteit
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] Slow performance Dspace 6.2

[Bill T]

Hi Tom!

/community-list performance is bad and worse!

DSpace 5.7 approx 18 seconds (this has always been a slow load -- we simply 
don't link to it)
DSpace 6.2 approx 80 seconds

we use xmlui

Oh, and the indexes mentioned in an earlier post HAVE been created...
Cheers!
Bill

On Thursday, January 25, 2018 at 12:38:29 PM UTC-6, Tom Desair (Atmire) 
wrote:
>
> Hi Bill,
>
> No problem ;-). I just have a few questions:
>
>1. How does the "/community-list" page performance of 6.2 compare to 
>DSpace 5?
>2. Are you using JSPUI or XMLUI?
>
> Best regards,
> Tom
>
>  
> [image: logo] Tom Desair
> 250-B Suite 3A, Lucius Gordon Drive, West Henrietta, NY 14586
> Gaston Geenslaan 14, Leuven 3001, Belgium
> www.atmire.com 
> 
>
> On Thursday, January 25, 2018 at 4:46:28 PM UTC+1, Bill T wrote:
>>
>> I am recently experimenting with v6.2 as well, and I am experiencing the 
>> same problems with community pages.  This is possibly not the best layout, 
>> but we essentially have 1 top level community which contains all other 
>> collections and communities which number about 1000. Performance loading 
>> this community was satisfactory in version 5.x, but has become extremely 
>> slow in v6.x.  Anonymous users see a load time of approximately 20 seconds. 
>>  Admin users see a somewhat faster load time, approximately 18 seconds. 
>>  Non-admin logged in users see a page load time of over 1 minute.  Any of 
>> these times prohibit us from going into production with DSpace 6.
>>
>> Other community pages are faster, depending on the number of sub 
>> collections/communities, but still too slow for production and much slower 
>> than v5.x
>>
>> Our setup is
>> RHEL 7
>> 8 cores, 32 GB
>> java 1.8.0, tomcat 8.5.14
>> postgresql 9.6.2
>>
>> This should be more than enough in terms of hardware and software, and 
>> ran DSpace 5 successfully.
>>
>> Is there anybody in the community with a similarly sized instance (1000 
>> communities and collections, 60,000 item records) running DSpace 6?
>>
>> Tom Desair addressed an even worse problem in the 'select collection' 
>> page of the submission form about a year ago;  Is there a similar problem 
>> on the community pages? (Sorry to pick on you Tom, that's what you get for 
>> being helpful).
>>
>> Any questions/comments/suggestions will be appreciated.  We would love to 
>> upgrade, but just can't with the performance I'm seeing.
>>
>> Thanks!
>> Bill
>>
>> On Tuesday, September 19, 2017 at 10:22:24 AM UTC-5, christian criollo 
>> wrote:
>>>
>>> Hi Tim
>>>
>>> Thanks for  the answer in the initial instaaltion the logs shown the 
>>> migration was successfully and the table schema_version too, this is not 
>>> the only problem what i have had 
>>> 
>>>
>>>
>>>
>>> 
>>>
>>>
>>>
>>> 
>>>
>>>
>>> 
>>>
>>>
>>>  
>>>
>>> El martes, 19 de septiembre de 2017, 9:31:23 (UTC-5), Tim Donohue 
>>> escribió:

 All,

 Just verifying that these indexes are supposed to be created 
 automatically (for either Oracle or Postgres) as they exist in the 6.0 
 database migration scripts:

 https://github.com/DSpace/DSpace/blob/dspace-6_x/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/oracle/V6.0_2015.03.07__DS-2701_Hibernate_migration.sql#L368

 It sounds like the migrations may not have all completed successfully. 
 Not sure why that would be. The logs from the initial installation may 
 have 
 provided more information as to whether the 
 "V6.0_2015.03.07__DS-2701_Hibernate_migration" migration succeeded or not. 
  
 You also could double check that your database reports successful 
 migrations by running [dspace]/bin/dspace database info   (This command 
 reports the current database status, and a larger table that lists all 
 database migrations and whether each has run successfully on the database.)

 Good luck,

 Tim


 On Tue, Sep 19, 2017 at 1:25 AM Alan Orth  wrote:

> Good to know, Christian. I don't use Oracle so I'm not sure, but I 
> assume that these indexes were supposed to be created by DSpace during 
> installation. Must be a bug.
>
> Regards,
>
> On Tue, Sep 19, 2017 at 12:50 AM christian criollo  
> wrote:
>

Re: [dspace-tech] Slow performance Dspace 6.2

[Hardy Pottinger]

Hi, there is a wiki page for performance tuning DSpace, you might check it
out:

https://wiki.duraspace.org/display/DSDOC3x/Performance+Tuning+DSpace

Alan's right, mostly it boils down to tuning your Tomcat memory settings.
Note that this advice only aplies to Tomcat 7 and earlier. During boot-up,
Tomcat 8 will explain to you patiently that the old heap settings will be
ignored every time you try to set them. So, a potentially easier thing to
do would be to move to Tomcat 8, as it will automatically better utilize
the memory it has available to to it.

--Hardy


On Thu, Sep 14, 2017 at 1:28 AM, Alan Orth  wrote:

> Hello,
>
> Your server should have enough power to run DSpace well. Is there anything
> else running on the server? How much of the machine's RAM is dedicated to
> the Java JVM heap? You can look in the "Java Information" section of the
> control panel when logged into DSpace as an administrator. Also, is your
> DSpace a clean installation or is there a lot of content submitted in it?
>
> Regards,
>
> On Wed, Sep 13, 2017 at 7:37 PM christian criollo 
> wrote:
>
>>
>> Hi Alan
>>
>> this is my configuration
>>
>> - Operating system version  R/  SUSE Linux Enterprise Server 11 (x86_64)
>> - PostgreSQL version R/ the database is Oracle Database 11g Release
>> 11.2.0.3.0 - 64bit
>> - Java version R/ java version "1.7.0_45"
>> - Tomcat version  R/ 7.0.50
>> - Hardware specifications of your server, like RAM and CPU R/ *three
>> proccesors* Intel(R) Xeon(R) CPU E5-2690 v4 @ 2.60GHz  *RAM * 5994588 kB
>>
>> I hope htis help
>>
>>
>>
>>
>> El miércoles, 13 de septiembre de 2017, 7:43:56 (UTC-5), Alan Orth
>> escribió:
>>
>>> Hello, Christian.
>>>
>>> You need to give us more information before we would be able to help
>>> you. For example:
>>>
>>> - Operating system version
>>> - PostgreSQL version
>>> - Java version
>>> - Tomcat version
>>> - Hardware specifications of your server, like RAM and CPU
>>>
>>> Regards,
>>>
>>> On Tue, Sep 12, 2017 at 6:02 PM christian criollo 
>>> wrote:
>>>
>>  Hi all

 Recently I installed Dspace 6.2 when I give click in a community,
 collection or item it takes too long to respond normally it should be a few
 secondswhat t could be happenning ?

  thanks for the help

 --
 You received this message because you are subscribed to the Google
 Groups "DSpace Technical Support" group.

>>> To unsubscribe from this group and stop receiving emails from it, send
 an email to dspace-tech...@googlegroups.com.
 To post to this group, send email to dspac...@googlegroups.com.
>>>
>>>
 Visit this group at https://groups.google.com/group/dspace-tech.
 For more options, visit https://groups.google.com/d/optout.

>>> --
>>>
>>> Alan Orth
>>> alan...@gmail.com
>>>
>>
>>> https://picturingjordan.com
>>> https://englishbulgaria.net
>>> https://mjanja.ch
>>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "DSpace Technical Support" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to dspace-tech+unsubscr...@googlegroups.com.
>> To post to this group, send email to dspace-tech@googlegroups.com.
>> Visit this group at https://groups.google.com/group/dspace-tech.
>> For more options, visit https://groups.google.com/d/optout.
>>
> --
>
> Alan Orth
> alan.o...@gmail.com
> https://picturingjordan.com
> https://englishbulgaria.net
> https://mjanja.ch
>
> --
> You received this message because you are subscribed to the Google Groups
> "DSpace Technical Support" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dspace-tech+unsubscr...@googlegroups.com.
> To post to this group, send email to dspace-tech@googlegroups.com.
> Visit this group at https://groups.google.com/group/dspace-tech.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] Slow performance Dspace 6.2

[Tom Desair (Atmire)]

Hi Bill,

No problem ;-). I just have a few questions:

   1. How does the "/community-list" page performance of 6.2 compare to 
   DSpace 5?
   2. Are you using JSPUI or XMLUI?

Best regards,
Tom

 
[image: logo] Tom Desair
250-B Suite 3A, Lucius Gordon Drive, West Henrietta, NY 14586
Gaston Geenslaan 14, Leuven 3001, Belgium
www.atmire.com 


On Thursday, January 25, 2018 at 4:46:28 PM UTC+1, Bill T wrote:
>
> I am recently experimenting with v6.2 as well, and I am experiencing the 
> same problems with community pages.  This is possibly not the best layout, 
> but we essentially have 1 top level community which contains all other 
> collections and communities which number about 1000. Performance loading 
> this community was satisfactory in version 5.x, but has become extremely 
> slow in v6.x.  Anonymous users see a load time of approximately 20 seconds. 
>  Admin users see a somewhat faster load time, approximately 18 seconds. 
>  Non-admin logged in users see a page load time of over 1 minute.  Any of 
> these times prohibit us from going into production with DSpace 6.
>
> Other community pages are faster, depending on the number of sub 
> collections/communities, but still too slow for production and much slower 
> than v5.x
>
> Our setup is
> RHEL 7
> 8 cores, 32 GB
> java 1.8.0, tomcat 8.5.14
> postgresql 9.6.2
>
> This should be more than enough in terms of hardware and software, and ran 
> DSpace 5 successfully.
>
> Is there anybody in the community with a similarly sized instance (1000 
> communities and collections, 60,000 item records) running DSpace 6?
>
> Tom Desair addressed an even worse problem in the 'select collection' page 
> of the submission form about a year ago;  Is there a similar problem on the 
> community pages? (Sorry to pick on you Tom, that's what you get for being 
> helpful).
>
> Any questions/comments/suggestions will be appreciated.  We would love to 
> upgrade, but just can't with the performance I'm seeing.
>
> Thanks!
> Bill
>
> On Tuesday, September 19, 2017 at 10:22:24 AM UTC-5, christian criollo 
> wrote:
>>
>> Hi Tim
>>
>> Thanks for  the answer in the initial instaaltion the logs shown the 
>> migration was successfully and the table schema_version too, this is not 
>> the only problem what i have had 
>> 
>>
>>
>>
>> 
>>
>>
>>
>> 
>>
>>
>> 
>>
>>
>>  
>>
>> El martes, 19 de septiembre de 2017, 9:31:23 (UTC-5), Tim Donohue 
>> escribió:
>>>
>>> All,
>>>
>>> Just verifying that these indexes are supposed to be created 
>>> automatically (for either Oracle or Postgres) as they exist in the 6.0 
>>> database migration scripts:
>>>
>>> https://github.com/DSpace/DSpace/blob/dspace-6_x/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/oracle/V6.0_2015.03.07__DS-2701_Hibernate_migration.sql#L368
>>>
>>> It sounds like the migrations may not have all completed successfully. 
>>> Not sure why that would be. The logs from the initial installation may have 
>>> provided more information as to whether the 
>>> "V6.0_2015.03.07__DS-2701_Hibernate_migration" migration succeeded or not.  
>>> You also could double check that your database reports successful 
>>> migrations by running [dspace]/bin/dspace database info   (This command 
>>> reports the current database status, and a larger table that lists all 
>>> database migrations and whether each has run successfully on the database.)
>>>
>>> Good luck,
>>>
>>> Tim
>>>
>>>
>>> On Tue, Sep 19, 2017 at 1:25 AM Alan Orth  wrote:
>>>
 Good to know, Christian. I don't use Oracle so I'm not sure, but I 
 assume that these indexes were supposed to be created by DSpace during 
 installation. Must be a bug.

 Regards,

 On Tue, Sep 19, 2017 at 12:50 AM christian criollo  
 wrote:

> Hi Alan
>
> I find the reason of slowly and the problem it was indexes database  
> in the table metadatavalue that strangely not executed the scripts are 
> the 
> next:
>
> CREATE INDEX metadatavalue_object on metadatavalue(dspace_object_id);
> CREATE INDEX metadatavalue_field_object on 
> metadatavalue(metadata_field_id, dspace_object_id);
>
> I executed this scripts and the performance of the  application 
> improve noticeably already respond 

Re: [dspace-tech] Slow performance Dspace 6.2

[Bill T]

I am recently experimenting with v6.2 as well, and I am experiencing the 
same problems with community pages.  This is possibly not the best layout, 
but we essentially have 1 top level community which contains all other 
collections and communities which number about 1000. Performance loading 
this community was satisfactory in version 5.x, but has become extremely 
slow in v6.x.  Anonymous users see a load time of approximately 20 seconds. 
 Admin users see a somewhat faster load time, approximately 18 seconds. 
 Non-admin logged in users see a page load time of over 1 minute.  Any of 
these times prohibit us from going into production with DSpace 6.

Other community pages are faster, depending on the number of sub 
collections/communities, but still too slow for production and much slower 
than v5.x

Our setup is
RHEL 7
8 cores, 32 GB
java 1.8.0, tomcat 8.5.14
postgresql 9.6.2

This should be more than enough in terms of hardware and software, and ran 
DSpace 5 successfully.

Is there anybody in the community with a similarly sized instance (1000 
communities and collections, 60,000 item records) running DSpace 6?

Tom Desair addressed an even worse problem in the 'select collection' page 
of the submission form about a year ago;  Is there a similar problem on the 
community pages? (Sorry to pick on you Tom, that's what you get for being 
helpful).

Any questions/comments/suggestions will be appreciated.  We would love to 
upgrade, but just can't with the performance I'm seeing.

Thanks!
Bill

On Tuesday, September 19, 2017 at 10:22:24 AM UTC-5, christian criollo 
wrote:
>
> Hi Tim
>
> Thanks for  the answer in the initial instaaltion the logs shown the 
> migration was successfully and the table schema_version too, this is not 
> the only problem what i have had 
> 
>
>
>
> 
>
>
>
> 
>
>
> 
>
>
>  
>
> El martes, 19 de septiembre de 2017, 9:31:23 (UTC-5), Tim Donohue escribió:
>>
>> All,
>>
>> Just verifying that these indexes are supposed to be created 
>> automatically (for either Oracle or Postgres) as they exist in the 6.0 
>> database migration scripts:
>>
>> https://github.com/DSpace/DSpace/blob/dspace-6_x/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/oracle/V6.0_2015.03.07__DS-2701_Hibernate_migration.sql#L368
>>
>> It sounds like the migrations may not have all completed successfully. 
>> Not sure why that would be. The logs from the initial installation may have 
>> provided more information as to whether the 
>> "V6.0_2015.03.07__DS-2701_Hibernate_migration" migration succeeded or not.  
>> You also could double check that your database reports successful 
>> migrations by running [dspace]/bin/dspace database info   (This command 
>> reports the current database status, and a larger table that lists all 
>> database migrations and whether each has run successfully on the database.)
>>
>> Good luck,
>>
>> Tim
>>
>>
>> On Tue, Sep 19, 2017 at 1:25 AM Alan Orth  wrote:
>>
>>> Good to know, Christian. I don't use Oracle so I'm not sure, but I 
>>> assume that these indexes were supposed to be created by DSpace during 
>>> installation. Must be a bug.
>>>
>>> Regards,
>>>
>>> On Tue, Sep 19, 2017 at 12:50 AM christian criollo  
>>> wrote:
>>>
 Hi Alan

 I find the reason of slowly and the problem it was indexes database  in 
 the table metadatavalue that strangely not executed the scripts are the 
 next:

 CREATE INDEX metadatavalue_object on metadatavalue(dspace_object_id);
 CREATE INDEX metadatavalue_field_object on 
 metadatavalue(metadata_field_id, dspace_object_id);

 I executed this scripts and the performance of the  application improve 
 noticeably already respond in seconds that is the normal

 thanks for your attention and help




 El jueves, 14 de septiembre de 2017, 1:28:55 (UTC-5), Alan Orth 
 escribió:

> Hello,
>
> Your server should have enough power to run DSpace well. Is there 
> anything else running on the server? How much of the machine's RAM is 
> dedicated to the Java JVM heap? You can look in the "Java Information" 
> section of the control panel when logged into DSpace as an administrator. 
> Also, is your DSpace a clean installation or is there a lot of content 
> submitted in it?
>
> Regards,
>

>