Multidimensional array question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to develop a multidimensional array for use of searching a very
large database. I understand the concept of one and two dimensional arrays
but this project would include up to 12 or 13 criteiras for the search. The
engine needs to be user friendly for general public use so the SQL/query path
method is not really an option for me. I have heard or read about
multidimensional cube arrays and am not sure if this is a viable method for
my project.

Any suggestions or code that might be usable would be greatly appreciated.
 
Hi BobbyS,

I'm not 100% sure I understand what you're asking. Are you looking to
provide 12 or 13 variables to a search method and expect results to be
returned?

Adam
 
Yes I am.

Adam May said:
Hi BobbyS,

I'm not 100% sure I understand what you're asking. Are you looking to
provide 12 or 13 variables to a search method and expect results to be
returned?

Adam
Click to expand...
 
I am trying to develop a multidimensional array for use of searching a very
large database. I understand the concept of one and two dimensional arrays
but this project would include up to 12 or 13 criteiras for the search.
The
engine needs to be user friendly for general public use so the SQL/query
path
method is not really an option for me. I have heard or read about
multidimensional cube arrays and am not sure if this is a viable method
for
my project.

Any suggestions or code that might be usable would be greatly appreciated.
Click to expand...

This is general advice, but IMO these approaches are always costly in time.
Even multiple criteria SQL searches are expensive. I have always found it
faster to search on the most restrictive criteria, using that to build a
list of record indexes, then select from that list slowly restricting until
you have a final list which you can then use to select the tuples you
require.

So I would use SELECT INDEX FROM TABLE WHERE FIELD < CONSTANT1 AND FIELD >
CONSTANT2 and repeat until I got the final list.

There is a belief abroad that database systems are magical and can perform
complex searches instantly. This belief is not supported by experience.
 
Back
Top