Results 1 to 11 of 11

Thread: SQL Speed

Threaded View

  1. Jan 31st, 2006, 01:56 PM #1
    manofsteel00
    manofsteel00 is offline

    Thread Starter
    Addicted Member
    Join Date
    Sep 2005
    Posts
    200

    SQL Speed

    I have VB6 program that uses SQL queries and an ADO connection to connect to a MS Access 2002 database. The database contains on an average 40,000+ records. The first screen in the program loads the contents of the database to a listbox; obviously this takes a while. The users want to maintain the ability to see everything, but want it to load faster. Is there a way to load faster via using a stored procedure in Access or something of that nature? Any suggestions are welcomed. Thanks.
    Last edited by manofsteel00; Jan 31st, 2006 at 02:01 PM. Reason: wording

    Nenio foriras ĝis ĝi havas instru ni kiu ni devas scii.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width