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
************************************************************************
**********************
If you are not the intended recipient, or person responsible for
delivering it to the intended recipient, you are not authorized to and
must not disclose, copy, distribute or retain this message or any part
of it.
The opinions / views / comments on this e-mail do not necessarily
reflect any views or policies of biznet
The recipient should check this email and any attachments for the
presence of viruses. biznet accepts no liability for any damage caused
by any virus transmitted by this email. biznet 2001.
************************************************************************
**********************
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
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
