Hendra
No, when I said SQL Engine I was referring to the SQL Server engine. You're right. Pass-throughs do not use the Jet/ACE engine. All the work is done on the SQL server side.
Bill
---In MS_Access_Professionals@yahoogroups.com, <agesthahendra@ymail.com> wrote:
---In MS_Access_Professionals@yahoogroups.com, <agesthahendra@ymail.com> wrote:
Thank you Bill,,,
What do you mean by "Sql Engine"?, is it JET/ACE?...i read many article that written more-less like this : "Pass Through Query let you bypass the JET/ACE and send the sql statement directly to the server"...i don't know what it exactly mean...but in my opinion it means that it's better to not use JET/ACE, sending the statement directly through ODBC is better....please direct me,,,thank you very much
Regards
Hendra Agestha
--------------------------------------------
Pada Sen, 3/3/14, wrmosca@comcast.net <wrmosca@comcast.net> menulis:
Judul: [MS_AccessPros] RE: All processes based on Sql Server Stored Proc.
Kepada: MS_Access_Professionals@yahoogroups.com
Tanggal: Senin, 3 Maret, 2014, 10:20 PM
HendraUnless you're talking about millions of records, I
don't see a need to use a stored procedure for a SELECT
since no action is done on the data. In fact, a view might
be better so you can control which columns are being
returned. As for the rest, it is usually quicker to let the
SQL engine do the work directly for high-use routines when a
large number of records are involved.
Bill
Mosca
---In MS_Access_Professionals@yahoogroups.com,
<agesthahendra@ymail.com> wrote:
Hi Everyone...
:)
Is that wise to rely every process Select, Insert, Update,
Delete based on Sql Server Stored Proc?
I really like the technique that using Pass Through Query to
exec. the SP on Sql Server...so i'm starting thinking to
do all DML and Select processes based on that technique as
far as it can do the task,,,please give some advice...it
would be very appreciated.
Regards
Hendra Agestha
What do you mean by "Sql Engine"?, is it JET/ACE?...i read many article that written more-less like this : "Pass Through Query let you bypass the JET/ACE and send the sql statement directly to the server"...i don't know what it exactly mean...but in my opinion it means that it's better to not use JET/ACE, sending the statement directly through ODBC is better....please direct me,,,thank you very much
Regards
Hendra Agestha
--------------------------------------------
Pada Sen, 3/3/14, wrmosca@comcast.net <wrmosca@comcast.net> menulis:
Judul: [MS_AccessPros] RE: All processes based on Sql Server Stored Proc.
Kepada: MS_Access_Professionals@yahoogroups.com
Tanggal: Senin, 3 Maret, 2014, 10:20 PM
HendraUnless you're talking about millions of records, I
don't see a need to use a stored procedure for a SELECT
since no action is done on the data. In fact, a view might
be better so you can control which columns are being
returned. As for the rest, it is usually quicker to let the
SQL engine do the work directly for high-use routines when a
large number of records are involved.
Bill
Mosca
---In MS_Access_Professionals@yahoogroups.com,
<agesthahendra@ymail.com> wrote:
Hi Everyone...
:)
Is that wise to rely every process Select, Insert, Update,
Delete based on Sql Server Stored Proc?
I really like the technique that using Pass Through Query to
exec. the SP on Sql Server...so i'm starting thinking to
do all DML and Select processes based on that technique as
far as it can do the task,,,please give some advice...it
would be very appreciated.
Regards
Hendra Agestha
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar