Hi,
I am trying to attach a large table (18million rows) from SQL2008 to geoserver.
When creating the new layer from within geoserver or reloading geoserver the
following call is being run on SQL Server.
SELECT "geom".STSrid FROM "theTable" WHERE "geom" IS NOT NULL.
That is a very large query on 18 million rows. I assume this is to look up the
SRID of the table. Can this query be disabled or rewritten to return only a
few rows?
In time I will have multiple tables of this size attached so it will make start
up a very slow process.
Thanks,
Ken
**********************************************************************
This e-mail from Ultra Electronics Limited and any attachments to it are
confidential to
the intended recipient and may also be privileged. If you have received it in
error please
notify the sender and delete it from your system. If you are not the intended
recipient
you must not copy it or use it for any purpose nor disclose or distribute its
contents to
any other person. All communications may be subject to interception or
monitoring for
operational and/or security purposes. Please rely on your own virus checking as
the sender
cannot accept any liability for any damage arising from any bug or virus
infection.
Ultra Electronics Limited is a company registered in England and Wales,
registration number
2830644. The address of its registered office is 417 Bridport Road, Greenford,
Middlesex, UB6 8UA.
**********************************************************************
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
