[EP-tech] Re: Simple search - length of query
sf2 at ecs.soton.ac.uk
Wed Mar 5 11:59:43 GMT 2014
Check this: https://github.com/eprints/eprints/issues/120
Without Xapian, the simple search will run SELECT's for each input word
for each "selected field in the simple search" so yep queries will get
long quickly. I've seen this to cause a repository to halt with any
other queries being locked until the max no of connections is reached in
Xapian searches in a totally different manner and scales up >
Hope this helps,
On 05/03/14 11:52, John Salter wrote:
> Yesterday we had a bit of an issue with our repository when someone pasted a full citation into the simple search box.
> This produced an impressive SQL query that locked things up and made users unhappy...
> Is there a way to sanitise what a 'simple' search might try to handle? e.g. would restricting it to a certain number of words be acceptable?
> Would the Xapian search handle a request like the one below any better?
> Details below/attached if you're interested!
> GET /cgi/search/simple?full=%E2%80%98Families%2C+Domesticity+and+Intimacy%3A+Changing+Relationships+in+Changi
> searchexp created in cache table:
> 0|1|-date/creators_name/title|archive|-|full:abstract/creators_name/date/documents/title:ALL:IN:?Families, Domesticity and Intimacy%3A Changing Relationships in Changing Times?, in Richardson, D, and Robinson, V. (eds) Introducing Women's Studies, third edition. Basingstoke%3A Palgrave, 2008 pp. 125-143. |-|eprint_status:eprint_status:ANY:EQ:archive|metadata_visibility:metadata_visibility:ANY:EQ:show
> The SQL generated by search is attached (get ready for this - it's a thing of beauty ;o) - you can see why it took a while to run!
> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: http://www.eprints.org/tech.php/
> *** EPrints community wiki: http://wiki.eprints.org/
> *** EPrints developers Forum: http://forum.eprints.org/
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Eprints-tech