SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Access: Queries vs. Straight SQL

    In an attempt to save some cash, I've decided to develop my new site using Access. Which wouldn't be that big an issue, as most data will be cached with .NET.

    But I thought I was enquire, which would offer better perfomace, straight SQL from .NET or queries?

    Been a long time since I used Access, and its 2003 I'm using.

    Cheers


  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,263
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    queries or SQL? what's the difference?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Wizard silver trophybronze trophy asp_funda's Avatar
    Join Date
    Jun 2003
    Location
    ether
    Posts
    4,497
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I think that he means whether stored queries in Access would be faster or dynamic SQL through .NET?

    I don't know of .NET but I've used stored queries in Access with ASP & it certainly is better than executing SQL Queries through ASP. And I've used it on Access2000, but I don't think that it would make much difference in favour of SQL Queries.
    Our lives teach us who we are.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Me - Photo Blog - Personal Blog - Dev Blog
    iG:Syntax Hiliter -- Colourize your code in WordPress!!

  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)
    No matter what the language you're using, the DB engine must parse the SQL. Using a stored query means that this is bypassed. Thus it's quicker to use a stored query than raw SQL in .Net, just as it is in every other language.

    I wouldn't want to let anyone by not being predictable, so you might want to refresh your memory of this article:
    http://www.15seconds.com/issue/020919.htm




    (In fact, since you have Access 2003, I'd be interested to know what the results of re-running my benchmarking code with a converted database {from 2000/2003 to 2003} are)
    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
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,263
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by M@rco
    thanks, m@rco, i do remember that

    in fact, i just checked, i actually have it bookmarked

    along with http://www.15seconds.com/issue/010514.htm

    "queries or SQL" obviously did not fire the right neurons in my head, but that's nobody's fault but mine
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  6. #6
    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)
    Quote Originally Posted by r937
    "queries or SQL" obviously did not fire the right neurons in my head, but that's nobody's fault but mine
    Too many beers tonight?!!
    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!

  7. #7
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,263
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    not tonight, no

    and not at 10 am on saturday, either, which is when i wrote that

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


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
  •