Database links in drawing

[Anonymous]

Hello,
I have a drawing file linked to an Access database. There's a little less than 20,000 rows, so its not that big. I've placed spatial and layer indexes on the drawing file data, and I've specified the ID field as a primary key within Access. I have no speed issues when I am querying the file from another drawing, however when I click on an object from within the base drawing itself in order to view the linked row, it takes more than a minute to bring up the linked row.
What can I do to speed it up?
Thanks,
Todd

[Anonymous]

If you are using Map 5 or 6 (I'm not sure about Map
4)

In the dataview under Records, use the Spatial Filter. It is
much faster than Highlight Records

You can also use the Spatial Filter to filter all of the
records in the current drawing, then use highlight

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"tmthies" <
href="mailto:thiest@ayresassociates.com">thiest@ayresassociates.com>
wrote in message
href="news:f1407de.-1@WebX.maYIadrTaRb">news:f1407de.-1@WebX.maYIadrTaRb...

Hello,

I have a drawing file linked to an Access database. There's a little less
than 20,000 rows, so its not that big. I've placed spatial and layer indexes
on the drawing file data, and I've specified the ID field as a primary key
within Access. I have no speed issues when I am querying the file from another
drawing, however when I click on an object from within the base drawing itself
in order to view the linked row, it takes more than a minute to bring up the
linked row.
What can I do to speed it up?
Thanks,

Todd

[Anonymous]

Thats the one, Jim.
Thanks a lot,
Todd