Author Topic: Linking diagram to database  (Read 3737 times)

0 Members and 1 Guest are viewing this topic.

squidwurrd

  • Jr. Member
  • **
  • Posts: 16
Linking diagram to database
« on: August 03, 2012, 11:45:28 AM »
When you connect a diagram to a sql data source after you select the rows and columns you I get a message that says:

Importing large amounts of data may negatively impact performance and increase file size. It is recommeneded that you filter the data to only include the rows and columns you intend to use in this diagram.

Would you like to configure additional column and row filters?

I want to know if the performace spoken about in the message is going to effect the local machine running visio or the sql server.

aledlund

  • Hero Member
  • *****
  • Posts: 1412
Re: Linking diagram to database
« Reply #1 on: August 03, 2012, 01:21:03 PM »
The performance hit is on the local machine. All of the rows/columns that you query end up as datarecordsets imported into the document. My personal preference is to create a view with the bare minimum of data actually required to be applied against the shapes (the entire datarecord that is imported is applied to shapedata even if only one column is required).
al

squidwurrd

  • Jr. Member
  • **
  • Posts: 16
Re: Linking diagram to database
« Reply #2 on: August 03, 2012, 03:09:55 PM »
THANKS!!!  ;D