I'm using FrontPage 2003 to edit Sharepoint Services 2.0 web sites. I want
to connect to an SQL Server 2000 database (running on a different server)
through a data view web part.

I can obtain the data connection and return results with no problem.
However, the query could return over 10000 rows, which makes Frontpage
ridiculously slow.

When I try to limit the number of results returned or enable paging through
the Data View Details taskpane, I still get all rows displayed in the
FrontPage design view, and after publishing, when browsing the Sharepoint
site as well.

Any ideas what is causing this, or how to work around it?

Thanks,
jason.

You might also try asking this in the WSS support newsgroup at
news://msnews.microsoft.com/microsof...indowsservices

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"wjasonstrutz" <(E-Mail Removed)> wrote in message news:50FB9501-978E-4409-917E-(E-Mail Removed)...
| I'm using FrontPage 2003 to edit Sharepoint Services 2.0 web sites. I want
| to connect to an SQL Server 2000 database (running on a different server)
| through a data view web part.
|
| I can obtain the data connection and return results with no problem.
| However, the query could return over 10000 rows, which makes Frontpage
| ridiculously slow.
|
| When I try to limit the number of results returned or enable paging through
| the Data View Details taskpane, I still get all rows displayed in the
| FrontPage design view, and after publishing, when browsing the Sharepoint
| site as well.
|
| Any ideas what is causing this, or how to work around it?
|
| Thanks,
| jason.