Hyland Community
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Advanced search SLOW!

lmoulin
Champ in-the-making
Champ in-the-making

‎03-02-2007 06:09 AM

Hello,
I have a large number of documents in the Alfresco repository (~100 000 documents).
The advanced search takes lots of time to return the results (~more than 60 seconds)
I use only the custom criteria to perform the advanced search.
I don’t use the google like search and the full text search.

I have set the following value in web-client-config.xml:
<search-max-results>100</search-max-results>

Have you got a hack to increase the performances of the advanced search?
Thanks a lot.
Luc
Labels:
0 Kudos
15 REPLIES 15

lmoulin
Champ in-the-making
Champ in-the-making

‎03-02-2007 10:12 AM

See the log of Alfresco system:
16:08:43,754 DEBUG [org.alfresco.web.bean.BrowseBean] Invalidating browse components…
16:09:02,916 DEBUG [org.alfresco.web.bean.BrowseBean] Invalidating browse components…
16:10:55,302 DEBUG [org.alfresco.web.bean.BrowseBean] Search results returned: 100
16:10:55,595 DEBUG [org.alfresco.web.bean.BrowseBean] Time to query and build map nodes: 112381ms
0 Kudos

andy
Champ on-the-rise
Champ on-the-rise

‎03-02-2007 10:30 AM

Hi

Exactly what query options are you selecting?

Andy
0 Kudos

lmoulin
Champ in-the-making
Champ in-the-making

‎03-05-2007 08:39 AM

The query is:
DEBUG [org.alfresco.web.bean.SearchContext] Query:  +@\{my.new.model\}erd_commercialisateur:"GAZ ELECTRICITE DE GRENOBLE" AND (( TYPE:"{my.new.model}custom_root_type"  OR  TYPE:"{http://www.alfresco.org/model/content/1.0}folder" ))

DEBUG [org.alfresco.repo.search.impl.lucene.LuceneQueryParser] Using Alfresco Lucene Query Parser for query:  +@\{my.new.model\}erd_commercialisateur:"GAZ ELECTRICITE DE GRENOBLE" AND (( TYPE:"{my.new.model}custom_root_type"  OR  TYPE:"{http://www.alfresco.org/model/content/1.0}folder" ))


I have created a new type 'custom_root_type' and a sub type 'erd'. I send you the full declaration of these customs types:
<types>
   <!– Super type for all custom types –>
   <type name="my:custom_root_type">
      <title>Custom Root Type</title>
      <parent>cm:content</parent>
      <properties>
         <property name="my:archive_id">
            <type>d:text</type>
         </property>
      </properties>
   </type>
   <type name="my:erd">
      <title>xxxx</title>
      <parent>my:custom_root_type</parent>
      <properties>
         <property name="my:erd_commercialisateur">
            <type>d:text</type>
         </property>
         <property name="my:erd_num_bordereau">
            <type>d:text</type>
         </property>
         <property name="my:erd_num_facture">
            <type>d:text</type>
         </property>
         <property name="my:erd_date_facture">
            <type>d:date</type>
         </property>
         <property name="my:erd_numero_pdl">
            <type>d:text</type>         
         </property>
      </properties>
   </type>
</types>


Thanks a lot for your help,
Luc
0 Kudos

andy
Champ on-the-rise
Champ on-the-rise

‎03-05-2007 11:23 AM

Hi

Can you tell us which version of Alfresco you are using, what Database, what  version you started with and what upgrades you have done (if any)?

Is the performance the same for the search "cold" and then run again?
Is the serach also slow for an admin user?

Cheers

Andy
0 Kudos

lmoulin
Champ in-the-making
Champ in-the-making

‎03-05-2007 11:43 AM

Hi,
I use Alfresco 1.4. It is a native version.
I have a PostGreSQL 8.1.3 database (postgresql-8.1-408.jdbc3.jar client):
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect

The ‘cold’ search takes around 100 seconds but if I run again the same query, the search takes 5 seconds !!!
If I am connected as admin user or a standard user, the search takes the same time.

My OS is MacPowerPC.

Regards,
Luc 😉
0 Kudos

derek
Star Contributor
Star Contributor

‎03-06-2007 03:43 AM

Hi,

We only covered testing Oracle and MySQL for the early 1.4.  This was extended to SQL Server and now includes PostgreSQL for Enterprise customers.  If you run on MySQL you won't have the same issues.

Regards
0 Kudos

lmoulin
Champ in-the-making
Champ in-the-making

‎03-06-2007 04:32 AM

Thanks a lot but for maintenances reasons I must use Alfresco with PostGreSQL.
But when Tomcat starts, the followings errors appears.
Do these errors have a link with my performance issue?


09:38:49,410 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - v1.5.0_06-112; maximum heap size 1012,625MB
09:38:49,411 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco started (Community Network): Current version 1.4.0 (build-105) schema 21 - Installed version 1.4.0 (build-105) schema 21
09:51:04,859 ERROR [org.alfresco.repo.content.transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to execute command: convert /opt/local/share/java/tomcat5/temp/Alfresco/ImageMagickContentTransformer_init_source_45594.gif  /opt/local/share/java/tomcat5/temp/Alfresco/ImageMagickContentTransformer_init_target_45595.png
09:51:20,992 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] Vrification des correctifs  appliquer …
09:51:21,040 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] Aucun correctif requis.
09:51:22,633 ERROR [org.alfresco.smb.protocol] Failed to get local domain/workgroup name, using default of WORKGROUP
09:51:22,634 ERROR [org.alfresco.smb.protocol] (This may be due to firewall settings or incorrect <broadcast> setting)
09:51:22,722 ERROR [org.alfresco.smb.protocol.netbios] NetBIOSNameServer setup error:
java.net.BindException: Permission denied
        at java.net.PlainDatagramSocketImpl.bind0(Native Method)
        at java.net.PlainDatagramSocketImpl.bind(PlainDatagramSocketImpl.java:82)
        at java.net.DatagramSocket.bind(DatagramSocket.java:368)
        at java.net.DatagramSocket.<init>(DatagramSocket.java:210)
        at java.net.DatagramSocket.<init>(DatagramSocket.java:261)
        at java.net.DatagramSocket.<init>(DatagramSocket.java:234)
        at org.alfresco.filesys.netbios.server.NetBIOSNameServer.openSocket(NetBIOSNameServer.java:1076)
        at org.alfresco.filesys.netbios.server.NetBIOSNameServer.run(NetBIOSNameServer.java:1548)
        at java.lang.Thread.run(Thread.java:613)
09:51:22,729 ERROR [org.alfresco.ftp.protocol] FTP Socket error
java.net.BindException: Permission denied
        at java.net.PlainSocketImpl.socketBind(Native Method)
        at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
        at java.net.ServerSocket.bind(ServerSocket.java:319)
        at java.net.ServerSocket.<init>(ServerSocket.java:185)
        at java.net.ServerSocket.<init>(ServerSocket.java:141)
        at org.alfresco.filesys.ftp.FTPNetworkServer.run(FTPNetworkServer.java:372)
        at java.lang.Thread.run(Thread.java:613)
09:51:23,514 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - v1.5.0_06-112; maximum heap size 1012,625MB
09:51:23,515 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco started (Community Network): Current version 1.4.0 (build-105) schema 21 - Installed version 1.4.0 (build-105) schema 21
09:51:23,520 ERROR [org.alfresco.smb.protocol] Server error :
java.net.BindException: Permission denied
        at java.net.PlainSocketImpl.socketBind(Native Method)
        at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
        at java.net.ServerSocket.bind(ServerSocket.java:319)
        at java.net.ServerSocket.<init>(ServerSocket.java:185)
        at java.net.ServerSocket.<init>(ServerSocket.java:141)
        at org.alfresco.filesys.smb.server.SessionSocketHandler.initialize(SessionSocketHandler.java:249)
        at org.alfresco.filesys.smb.server.NetBIOSSessionSocketHandler.createSessionHandlers(NetBIOSSessionSocketHandler.java:158)
        at org.alfresco.filesys.smb.server.SMBServer.run(SMBServer.java:487)
        at java.lang.Thread.run(Thread.java:613)

Luc
0 Kudos

alexander
Champ in-the-making
Champ in-the-making

‎03-06-2007 05:44 AM

Most of the errors are based on the fact that user, under which process is started, does not have to required ports for FTP, SMB etc.

First error is due to the fact, that system can not find "convert" shell command - part of ImageMagic package.

It should not have any link to performance issues.

Thanks
Alexadner
0 Kudos

lmoulin
Champ in-the-making
Champ in-the-making

‎03-06-2007 05:53 AM

Thanks,
I have a other information about my webapp.
Its name is 'erd' and not 'alfresco'.  Smiley Happy
Does this name have a link with my performance issue?

Luc
0 Kudos
Getting started

Tags

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.

Copyright © 2025 Khoros, LLC