Hi all, I saw the recent posts about Search Functionality and how some of you, Adrian included, are using it for searching. I'd like your opinion on whether Swish-e would make sense for searching/indexing 12 varchar(<=255) fields in a large table (~10M records).
The search is currently taking a 'long time' (about 28 seconds from the user's perspective) using a custom pager and django's query api. Each 'page' requires two long queries on the db, one to get the records for the page (about 13s) and another to get the count of records (about 12s). I've not used Swish-e before. Is there any chance it would be faster than the straight db search we are doing now? Thanks in advance, Eric. More info: $ uname -mo x86_64 GNU/Linux This is a dedicated data server, django (the sargasso formerly known as pre_magic_removal) is running on another machine. $ psql --version psql (PostgreSQL) 8.1.3 $ cat /proc/cpuinfo processor : 0 vendor_id : AuthenticAMD cpu family : 15 model : 5 model name : AMD Opteron(tm) Processor 246 stepping : 10 cpu MHz : 1991.776 cache size : 1024 KB $ cat /proc/meminfo MemTotal: 4059872 kB --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---
