Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2005
    Posts
    196

    Unanswered: Replacing queries with ADO

    Hi,

    I have a query in my database which I populate my form by opening it using ADO. This query relies on about 8 other queries running behind it.

    What I would like to do is replace the queries that help to build up the main query with sub queries in a SQL string, and call them using ADO so basically, I will have one long SQL string which will have sub queries in to replace the 8 queries in my database. I will then open this sql string with ADO.

    Before I do this, I basically need to know if this will have a positive effect on performance or will there be no difference?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    It will most likely slow it down ... With stored queries, you get compiled and optimized SQL code ... Doing it in ADO will require the compile and optimize step on the fly ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Concur. Not to mention the debugging nightmare.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Aug 2005
    Posts
    196
    Quote Originally Posted by pootle flump
    Concur. Not to mention the debugging nightmare.
    Don't I know it!!! Thanks very much to both of the above for your help.
    Last edited by Fuerteventura; 06-27-07 at 12:47.

Posting Permissions

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