cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forĀ 
ShowĀ Ā onlyĀ  | Search instead forĀ 
Did you mean:Ā 
Exit
search
  • Global community
    • Language:
      • Deutsch
      • English
      • EspaƱol
      • FranƧais
      • PortuguĆŖs
  • ę—„ęœ¬čŖžć‚³ćƒŸćƒ„ćƒ‹ćƒ†ć‚£
  • ķ•œźµ­ ģ»¤ė®¤ė‹ˆķ‹°
0
Upvote

Improve Poor Performace with SQL 8 database

weezerboy
Participant ,
Jul 09, 2013 Jul 09, 2013

I just migrated my last MS Access database over to SQL Server 8 database.

I have  tables with 100-20,000 rows in them.

My question is what can I do to improve performance (page load time)?

I have pages that are taking 10 seconds to load that took 2 seconds with Access...I expected improvement with MSSQL.

I have indexed tables etc...

Is there something in the CF code I need to modify also.

I am using CF9

TOPICS
Database access
740
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation
Resources
Documentation
ColdFusion User Guide
Open in a new window
Copyright Ā© 2025 Adobe. All rights reserved.
Using the Community Experience League Terms of Use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices