SitePoint Sponsor |
|
User Tag List
Results 1 to 5 of 5
-
Sep 20, 2002, 06:02 #1
- 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
-
Sep 20, 2002, 07:03 #2
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!Drupal Development -- Hire me!
Drupal Training | Darwin Awards Moderator | Classic Cars
SitePoint | Blog | Rent Games Online | Car | Talent
-
Sep 20, 2002, 09:44 #3
- 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 ... ?Morning person by habit, not by nature.
-
Sep 26, 2002, 12:22 #4
- 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!
-
Sep 26, 2002, 12:33 #5
- 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