kitwalker

02-12-2008, 02:05 AM

I've been trying to run a very large search on the BGM database limiting it to the NT only.

The search is:

/boulomai dehsij enteuxij entugcanw epizhtew eucaristew eudokia euch eucomai proseuch proseucomai fulakthrion zhtew qelw filoprwteuw eufrainw sugcairw cairw anqomologeomai eucaristia eucaristoj carij adw ainesij ainew ainoj allhlouia apodecomai doxazw exomologew epainew epainoj eulogew euloghtoj eulogia eufhmoj omologew sundoxazw umnew umnoj yallw yalmoj aitew axiow apaitew deomai dierwtaw exaitew eperwtaw erwtaw paraiteomai punqanomai

If I search about a third of the terms at a time I get what looks like a valid result.

If I search roughly half the terms it will do the search after a long wait but comes up with only a handful of verses when it is quite clear that there are many more from individual searches.

If I search all the terms the computer appears to crash. (I'd love to be able to run the search in one hit as it would remove duplicate verses from individual smaller searches).

So is there a theoretical limit to the number of terms you can use in an 'or' search? At what point does number of terms cause the search result to be invalid as when I search half the terms.

Or can someone else perform the search ok and the answer is that I just need a more powerful computer? :rolleyes:

Thanks for any help someone might be able to provide.

The search is:

/boulomai dehsij enteuxij entugcanw epizhtew eucaristew eudokia euch eucomai proseuch proseucomai fulakthrion zhtew qelw filoprwteuw eufrainw sugcairw cairw anqomologeomai eucaristia eucaristoj carij adw ainesij ainew ainoj allhlouia apodecomai doxazw exomologew epainew epainoj eulogew euloghtoj eulogia eufhmoj omologew sundoxazw umnew umnoj yallw yalmoj aitew axiow apaitew deomai dierwtaw exaitew eperwtaw erwtaw paraiteomai punqanomai

If I search about a third of the terms at a time I get what looks like a valid result.

If I search roughly half the terms it will do the search after a long wait but comes up with only a handful of verses when it is quite clear that there are many more from individual searches.

If I search all the terms the computer appears to crash. (I'd love to be able to run the search in one hit as it would remove duplicate verses from individual smaller searches).

So is there a theoretical limit to the number of terms you can use in an 'or' search? At what point does number of terms cause the search result to be invalid as when I search half the terms.

Or can someone else perform the search ok and the answer is that I just need a more powerful computer? :rolleyes:

Thanks for any help someone might be able to provide.