jBox Queryby Rect performance

[Fernando Simon]

Hi John,
The time is always slow to generate the map? Or only with query's?
Can you post your definition for the data parameter? Are you using
native connection or OGR connection? Did you created the index (spatial
index) for your table? It's Oracle Spatial or just Oracle?
Best regards.

------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://www.univali.br/g10 - UNIVALI/CTTMAR
------------------------------------------------------------------------


John Li wrote:
> Dear All,
> I am trying to use jBox to perform query by selecting point records by
> rectanglar select (drag an area in which point records are displayed).
> However, it seems that it takes long time to generate the map image (I
> have added some labeling features on the map request). I have tried to
> create index on XY and record ID, but the performance has not improved.
> Is there something I can do to solve this problem? Is the problem
> related to database index, or jBox, or anything else?
> I am using MapServer, jBox, Win 2003 Server, IIS, Oracle.
> Hope you can give me some hints.
> Regards,
> John