Subject | Re: [firebird-support] There must be a better way. |
---|---|
Author | Fabrizio Lozada |
Post date | 2005-09-02T01:21:12Z |
Mmmm looks like a task for htdig://
--- Nigel Weeks <nweeks@...> escribió:
---------------------------------
I'm putting a search facility on our intranet, and
I've hit a wall.
My current idea is:
A table of words, with an integer key
Create table tbl_words (
int_word integer not null primary key,
str_word varchar(100) not null unique
);
A table of word id's, linked to an address
Create table tbl_pageword (
int_page integer not null,
int_word integer not null,
str_href varchar(200) not null,
primary key(int_page, int_word, str_href)
);
The problem is, doing 'and' searches.
For example: find the pages that contain ALL THREE
TERMS 'beer',
'chocolate', '4WD'
Subselects are slower than I'd like, as a new word
lookup has to be done for
each word. For example:
Select str_href from tbl_pageword where
int_word in (select int_word from tbl_words where
str_word = 'beer')
AND int_word in (select int_word from tbl_words where
str_word =
'chocolate')
AND int_word in (select int_word from tbl_words where
str_word = '4WD');
There has to be a better way. Any ideas? Even a
complete schema change is
welcomed.
Nige.
Nigel Weeks
Tech Support & Systems Developer
nweeks@...
www.examiner.com.au
71 - 75 Paterson Street
Launceston
Tasmania 7250
Australia
Phone: 03 6336 7234
[Non-text portions of this message have been removed]
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://firebird.sourceforge.net and click the
Resources item
on the main (top) menu. Try Knowledgebase and FAQ
links !
Also search the knowledgebases at
http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
SPONSORED LINKS
Technical support
Computer technical support
Compaq computer technical support
Compaq technical support
Hewlett packard technical support
Technical support services
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "firebird-support" on the web.
To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.
---------------------------------
___________________________________________________________
Do You Yahoo!?
La mejor conexión a Internet y <b >2GB</b> extra a tu correo por $100 al mes. http://net.yahoo.com.mx
--- Nigel Weeks <nweeks@...> escribió:
---------------------------------
I'm putting a search facility on our intranet, and
I've hit a wall.
My current idea is:
A table of words, with an integer key
Create table tbl_words (
int_word integer not null primary key,
str_word varchar(100) not null unique
);
A table of word id's, linked to an address
Create table tbl_pageword (
int_page integer not null,
int_word integer not null,
str_href varchar(200) not null,
primary key(int_page, int_word, str_href)
);
The problem is, doing 'and' searches.
For example: find the pages that contain ALL THREE
TERMS 'beer',
'chocolate', '4WD'
Subselects are slower than I'd like, as a new word
lookup has to be done for
each word. For example:
Select str_href from tbl_pageword where
int_word in (select int_word from tbl_words where
str_word = 'beer')
AND int_word in (select int_word from tbl_words where
str_word =
'chocolate')
AND int_word in (select int_word from tbl_words where
str_word = '4WD');
There has to be a better way. Any ideas? Even a
complete schema change is
welcomed.
Nige.
Nigel Weeks
Tech Support & Systems Developer
nweeks@...
www.examiner.com.au
71 - 75 Paterson Street
Launceston
Tasmania 7250
Australia
Phone: 03 6336 7234
[Non-text portions of this message have been removed]
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://firebird.sourceforge.net and click the
Resources item
on the main (top) menu. Try Knowledgebase and FAQ
links !
Also search the knowledgebases at
http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
SPONSORED LINKS
Technical support
Computer technical support
Compaq computer technical support
Compaq technical support
Hewlett packard technical support
Technical support services
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "firebird-support" on the web.
To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.
---------------------------------
___________________________________________________________
Do You Yahoo!?
La mejor conexión a Internet y <b >2GB</b> extra a tu correo por $100 al mes. http://net.yahoo.com.mx