Philip,
I just scanned through the docs for DBD::Xbase and noticed the last
sentence of the description states:
The DBD::XBase doesn't make use of index files at the moment. If you
really need indexed access, check XBase(3) for notes about support for
variour index types.
If its possible in your situation, another solution would be upgrading to
a better database, like MySQL and Postgres, that do have support for
indexes with their DBD drivers.
chris
On Thu, 3 May 2001, Phillip Perkins wrote:
> See, that's just the thing. There is an index file with a tag reference even on the
> field that I'm using in my where clause. However, (I just skimmed over the mod code,
> so I don't know how accurate my eval is) it appears that w/ or w/o an index the
> DBI::XBase driver will read each record sequentially and check each record until it
> reaches EOF, and it will return an array only on those records that match the
> criteria. I haven't seen anything yet (other than prepare_select_with_index in the
> original XBase mod) to tell DBI how to use an index like a "hint" in SQL.
>
> Phillip
>
