David Emerson
newsgrps at dalyn.co.nz
Sun Jul 24 11:44:19 CDT 2005
Group, Access XP adp, SQL2000. I have a stored procedure which is the rowsource for a combo box thus: ALTER PROCEDURE spcbofrmCustServicePlansServicePlan AS SET NOCOUNT ON SELECT SQLLtdbe.dbo.tblServiceRates.ServiceRateID, SQLLtdbe.dbo.tblServicePlans.Name, SQLLtdbe.dbo.tblServicePlanDistrict.District, SQLLtdbe.dbo.tblServiceRates.CurrentPlan as "Current" FROM SQLLtdbe.dbo.tblServicePlanDistrict INNER JOIN (SQLLtdbe.dbo.tblServicePlans INNER JOIN SQLLtdbe.dbo.tblServiceRates ON (SQLLtdbe.dbo.tblServicePlans.ServicePlanID = SQLLtdbe.dbo.tblServiceRates.ServicePlanIDNo)) ON (SQLLtdbe.dbo.tblServicePlanDistrict.ServPlanDistrictID = SQLLtdbe.dbo.tblServiceRates.DisctrictIDNo) ORDER BY SQLLtdbe.dbo.tblServiceRates.CurrentPlan DESC, SQLLtdbe.dbo.tblServicePlanDistrict.District, SQLLtdbe.dbo.tblServicePlans.Name It returns about 3600 records. This runs ok when the adp is connected to SQLLtdbe. However, when I connect to another SQL database which also has the same sproc, it takes over 1/2 a minute from when the drop down list is opened to when a selected item appears in the combo box. The screen seems to freeze between selecting the item and when the list automatically closes and the item is left in the box. It seems to be an issue of time taken to get all the data from the other database to populate the combobox. Are there any tips in speeding up the process (apart from reducing the number of items in the list)?