Optimizing attribute search time.

[Puneet Kishor]

Luca Manganelli wrote:
> Hi,
> 
> there's a way to optimize attribute search time in mapserver?
> I.E.: i have a 17MB dbf (with its shp file) of streets with names.
> Mapserver isn't fast: a search on an Athlon 3400+ and 2GB RAM
> ends in 6 seconds, which is unacceptable for us.


have you benchmarked your app? Which part is slow? Is it slow searching 
through the dbf or finding the relevant shape? Are you using MapScript 
or CGI?

> 
> Is there any way to improve the time? 1-2 seconds would be good.

put the dbf in a real database.