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
************************************************************************
**********************
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.
************************************************************************
**********************
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
