SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    \m/ R.I.P. Dimebag! \m/ JimBolla's Avatar
    Join Date
    Dec 2001
    Location
    erie, pa
    Posts
    1,130
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Do Stored Queries Increase the Speed of Access Queries?

    Huzzah to M@rco on his recently published article on 15seconds.com, titled "Do Stored Queries Increase the Speed of Access Queries?"
    -- JIM BOLLA
    Wanna play Halo 2? My XBOX Live gamertag: crowdozer

  2. #2
    Drupaler bronze trophy greg.harvey's Avatar
    Join Date
    Jul 2002
    Location
    London, UK
    Posts
    3,258
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Good stuff. I can't put that into practice sadly, as you need Access running on the web server don't you ... ?

    One other thing Marco missed when setting the background was option three, keeping your regularly used SQL strings in an SI. Anyway. I'm nit-picking. Good stuff mate! Shame I'm migrating all my stuff to MSDE!

  3. #3
    SitePoint Zealot JEmLAC's Avatar
    Join Date
    Apr 2002
    Location
    Kansas City
    Posts
    156
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by greg.harvey
    [B]Good stuff. I can't put that into practice sadly, as you need Access running on the web server don't you ... ?
    Actually, I believe what Marcus is talking about would apply in any application that is interacting with an Access database via ADO. This would include Web servers or desktop applications.
    Morning person by habit, not by nature.

  4. #4
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks CrowDozer! I mentioned it to DaveMaxwell, but was wondering if anyone kept an eye on 15Seconds.com (I've recommended it enough times )!!!


    JEmLAC, you're quite correct - as I have explained many times in the past in these forums, "Access databases" are really just JET4 databases (which are stored on disk with an .mdb file extension), and do not require the presence of Access (the desktop app) to function, only ADO.

    Access (the app) is merely an impressive frontend to the ADO and ADOX objects, which do all the work of interacting with the .mdb on the disk.

    Hence referring to .mdb files as "Access databases" is an unfortunate misnomer, but since that's the established norm, it's not going to change any time soon.
    (I would have hoped that all of this would be common knowledge and well-understood by now, but perhaps not)


    greg.harvey - Thanks, but I'm afraid that I don't quite follow your reference to "keeping your regularly used SQL strings in an SI". When you hardcode an SQL statement in a script this is exactly what you are doing, so how is this another option??!
    Last edited by M@rco; Sep 26, 2002 at 12:28.
    MarcusJT
    - former ASP web developer / former SPF "ASP Guru"
    - *very* old blog with some useful ASP code

    - Please think, Google, and search these forums before posting!

  5. #5
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    BTW - Has anyone run the benchmarks themselves? If so, did you get similar results?
    MarcusJT
    - former ASP web developer / former SPF "ASP Guru"
    - *very* old blog with some useful ASP code

    - Please think, Google, and search these forums before posting!


Bookmarks

Posting Permissions

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