Using Swish-e with django...

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-usersgooglegroups.com
To unsubscribe from this group, send email to
django-users-unsubscribegooglegroups.com
For more options, visit this group at http://gr
oups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---