: > Thank you for your reply, your solution doesnt work in my case because I
: > was thinking of indexing more than one document in a single index and each
: > document representing a table in database. so if I put more than one
: > document some fields for a single document will be empty. somethi
Any more idea?
On 4/17/07, Mohammad Norouzi <[EMAIL PROTECTED]> wrote:
Chris,
Thank you for your reply, your solution doesnt work in my case because I
was thinking of indexing more than one document in a single index and each
document representing a table in database. so if I put more than one
Chris,
Thank you for your reply, your solution doesnt work in my case because I was
thinking of indexing more than one document in a single index and each
document representing a table in database. so if I put more than one
document some fields for a single document will be empty. something like
t
> > Query:
> > field1:"test phrase" AND field2:"test" AND field3:field4
> >
> > in this query we said that do search where field3 is equal to
> > field4 ...
> > (and rest of the query)
Regarding your query, I think you can simply query the database and
create a field, like f3f4, and set it to 1
well, let me tell you what we're going to do.
our information are too much. actually, we have a huge database for
hospitals, and their services and their patients and also pharmacy infos.
just for test, we first joined some important tables and as you said
de-normalized them and then tried to cre
well, how much data are we talking about here? If your index
is already 100G, your options are much more limited than if
it's 1M...
Essentially, you have several choices:
1> de-normalize your data to whatever extent is "sufficient"
and index it.
2> Try to do what amount to joins. If your needs
Thanks Karl,
sorry I was on business vacation and could not reply soon.
Ok, I want to index my database and search through the indexes, and the
tables in database are more than 50 and it's hard to joining them and then
indexing. so I was thinking of indexing each table in a document but in one
in
11 apr 2007 kl. 11.19 skrev Mohammad Norouzi:
is it possible (or a trickery way) to search with a given query in
which we
can set an equality for two fields
for example:
Document:
field1 field2field3 field4
Query:
field1:"test phrase" AND field2:"test"
