sql vs. stored queries in jet 
Author Message
 sql vs. stored queries in jet

You should not use Access in a network environment. Either using SQL or Query
you will always get a much greater traffic in your network than if you were
using a database like SQL Server.
But if you have to use Access, Queries run a little faster than SQL statements
because they don't need to be interpreted by database engine.

Quote:

> With an access database and vb5 front end, does anyone have a preference
> between stored querydefs vs. sql for populating recordsets. Things like
> which is faster, which creates less network traffic, etc.

> I'm doing a lot of tests on this right now, as well, and was wondering what
> others have found.  On the Net I've found a lot of references implying
> don't use sql in vb3, but not much that's been updated.

> --
>  David Foster            |  "But I've been to the pointless forest,

>  finger for PGP key      |              -- Oblio, The Point

--
Cludio Avolio Rodrigues
Systems Especialist
IBM GS

Home page: http://www.*-*-*.com/

Please remove NOSPAN from username to reply.



Sat, 22 Jul 2000 03:00:00 GMT  
 sql vs. stored queries in jet

Stored querydefs will be faster because they're store compiled.

    - Rebecca.

Quote:

>With an access database and vb5 front end, does anyone have a preference
>between stored querydefs vs. sql for populating recordsets. Things like
>which is faster, which creates less network traffic, etc.

>I'm doing a lot of tests on this right now, as well, and was wondering what
>others have found.  On the Net I've found a lot of references implying
>don't use sql in vb3, but not much that's been updated.

>--
> David Foster            |  "But I've been to the pointless forest,

> finger for PGP key      |              -- Oblio, The Point



Sun, 23 Jul 2000 03:00:00 GMT  
 sql vs. stored queries in jet

I don't think ought to make blanket statements like "You should not use
Access in a network environment."  While it's true that a client-server
environment is _generally_ faster, particularly with large database or lots
of concurrent users, but there's a lot of overhead involved, overhead which
is not (imho) always justified.

    - Rebecca.

Quote:

>You should not use Access in a network environment. Either using SQL or
Query
>you will always get a much greater traffic in your network than if you were
>using a database like SQL Server.
>But if you have to use Access, Queries run a little faster than SQL
statements
>because they don't need to be interpreted by database engine.


>> With an access database and vb5 front end, does anyone have a preference
>> between stored querydefs vs. sql for populating recordsets. Things like
>> which is faster, which creates less network traffic, etc.

>> I'm doing a lot of tests on this right now, as well, and was wondering
what
>> others have found.  On the Net I've found a lot of references implying
>> don't use sql in vb3, but not much that's been updated.

>> --
>>  David Foster            |  "But I've been to the pointless forest,

>>  finger for PGP key      |              -- Oblio, The Point

>--
>Cludio Avolio Rodrigues
>Systems Especialist
>IBM GS

>Home page: http://www.geocities.com/SunsetStrip/4994

>Please remove NOSPAN from username to reply.



Sun, 23 Jul 2000 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Jet 3.0 vs Jet 3.5 table locking during queries

2. Stored queries vs. Dynamic SQL directly in code

3. Inline SQL vs. stored parameter query

4. Inline SQL vs. stored parameter query

5. VB code SQL vs DB Stored queries

6. Inline SQL vs. stored parameter query

7. STORED QUERY Vs DYNAMIC SQL WARNING?????

8. Jet 3.51 vs Jet 4.0 vs MSDE

9. SQL vs JET - SQL Statement Syntax

10. Jet DB Performance (Jet 3.51 vs. Jet 4.0)

11. VB Query vs SQL Query Analyzer Speed?

12. Converting dynamic query by example SQL to RDO based SQL Stored Procedure

 

 
Powered by phpBB® Forum Software