Memory issues? MS SQL 2000 will use a lot more memory. When working with small tables and datasets you may be staying within the bounds of physical memory on the machine and never notice a difference. If you force the system to use virtual memory, though, the slowdown could be the effects of swapping to disk.
Jim ----- Original Message ----- From: "Jerry Staple" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 22, 2002 9:33 AM Subject: RE: Access /SQL Server > Andy, > It is only selecting data and it is running on the same server > as the access versions? > > We would appreciate any advice. > > Jerry > > -----Original Message----- > From: Andy Ewings [mailto:[EMAIL PROTECTED]] > Sent: 22 April 2002 16:13 > To: CF-Talk > Subject: RE: Access /SQL Server > > > Sounds like the majority processing on this page is CF. Check the > debugging > output and see how long the SQL queries take. If your SQL queries are > taking a noticable abmount of time then I'd suggest ensuring that your > indexes are correct and that your Transact SQL is effecient. Without > seeing > the code it's hard to suggest what it is. Is this page > inserting/updating/or deleting data? if so your indexes will increase > the > time it takes to execute the SQL statement and hence the page as all of > your > indexes have to be rebuilt when an action other than a select is > performed > on the table. > > -----Original Message----- > From: Jerry Staple [mailto:[EMAIL PROTECTED]] > Sent: 22 April 2002 16:08 > To: CF-Talk > Subject: Access /SQL Server > > > Hi, > We have recently migrated an access database to sql server 2000. The > transfer has gone great and the site runs quicker in 98% of the site > However there is one page (around 1500 lines of code) which carries out > allot of calculations and references 2 tables with about 200000 records > in each of them. We have found that the page still runs quicker in an > access database than a sql server db, we have also checked indexes and > created stored procedure for a number of the queries. > > Can anyone tell me what we should check for as currently it is running > about 3 times slower? > > TIA > > > Jerry Staple > Web Application Developer > Certified Coldfusion (5.0) Developer > > > Head Office > 133-137 Lisburn Road, Belfast > Northern Ireland BT9 7AG > T +44 (0) 28 9022 3224 > F +44 (0) 28 9022 3223 > E [EMAIL PROTECTED] > W www.biznet-solutions.com ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
