![]() ![]() 'name' LIKE 'alan%' (may return 20 records).'name' LIKE 'ala%' (may return 75 records).'name' LIKE 'al%' (may return 500 records).'name' LIKE 'a%' (may return 10000 records).Look out for full index or full table scansĪuto-complete queries are a special case, in that they usually works as ever decreasing sub sets. Joins: Ensure your JOINs are in place and are optimized by the query planner. SQL Performance - Indexes and the LIKE clause ). There is an excellent article on the topic at myitforum. (Yes, in many cases LIKE does use the indexes. Indexes: Ensure that you have indexes setup. LIKE queries will not put too much strain on your database, as long as you spend time using 'EXPLAIN' or the profiler to show you how the query optimiser plans to perform your query. ![]() Unfortunately, the resolution of this issue will depend heavily on the data you are hoping to query. It would be nice if it could be accesed by http or sockets.numbers to which you know it can scale.What I would like to hear is implementation used by sites and numbers of how well it can handle load preferable with: I also read in this thread about how to implement this in java (lucene and some library created by shilad).Maybe something like in memory redis trie which I also haven't tested performance on.I don't know the performance of this so users with big sites please tell me.Using something like solr terms like for example:.I think this implementation will blow up with a lot of simultaneously users or large data set, but maybe I am wrong so numbers(which could be handled) would be cool.simple SQL like for example: SELECT name FROM users WHERE name LIKE al%.But I could not find a good thread about this on stackoverflow (maybe did not look good enough).įor example autocomplete names: names: I think there are enough topic about this on stackoverflow. So no browserside javascript autocomplete(yui/jquery/dojo). I would to know if there are any libraries out there which can do autocomplete efficiently(serverside) which preferable can fit into RAM(for best performance). If the admin interface is visible then everything is set.Īpache Solr is a very large and complex project that has a lot of configuration that can be changed to improve your search, so go explore it and have fun with it.Premature optimization is the root of all evilīut I think wrong autocomplete can really blow up your site. To check if everything is running properly, got to the Apache Sorl admin interface by visiting: http//localhost:8983/solr/admin. The last step is to go to admin/settings/apachesolr from the drupal toolbar, click on 'Advanced Configuration' and make Apache Solr as the default search If you don't have java installed, run the following command to get the latest default JDK packages from the repository: Note: you need java installed on your server to run the above command. tgz archive (in my case it is /home/Servers/Apache-Solr-3.6.2/example) and running this command: The first option is the preferred method in case anything goes wrong and you want to keep the original configuration files.Īt this time the Apache Solr server can be started by going to the directory where you extracted Solr files from the. ) before copying them or then can be overriden, either way will work properly. Sites/all/modules/apachesolr/solr-conf/solr-3.x/ to /home/Servers/apache-solr-.3.x/example/solr/confĪny files that have the same name can be renamed to (eg. The next step is to copy the configuration files (all files) inside Once the above three steps are done, extract the contents of Apache Solr 3.6.2 to a directory like: /home/Servers. tgz to your server box. Make sure it is outside your drupal installation folder and is outside of your web root/folder. Apache Solr Autocomplete - Download and Enableģ. Apache Solr Search Integration - Download and EnableĢ. To begin using Apache Solr 3.6.2 in a Drupal website the following files and modules will be needed to get started:ġ. Solr can run as a standalone full-text search server on a separate server box to reduce server load on a server where MySQL and PHP are running. Solr is considered the "gorilla" of search by many and anyone who has used it can attest to that. Apache Solr is an open source project that is used on many high traffic websites like and is well integrated into Drupal. This is where Apache Solr comes into play. Although Drupal has a good built-in search functionality that coumes out of the box, sometimes a client wants something more advanced and feature rich that scales well for a quickly growing website. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |