IWETHEY v. 0.3.0 | TODO
1,095 registered users | 2 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Theory and Practice of Programming Forum / There is an osql
Post #186,332
by altmann
12/7/04 6:42:41 PM
12/7/04 6:43:59 PM
Reply
New There is an osql
and a SET SHOWPLAN_TEXT (or SHOWPLAN_ALL)

MSDE (what I assume is meant by "runtime") should have the osql CLI tool.

There's also a registry setting to turn plan logging on for the Jet engine that Access uses.

[link|http://builder.com.com/5100-6388-5064388.html|http://builder.com.c...6388-5064388.html]

[edit: removed restatment of your statement :)]
--
Chris Altmann
Collapse Edited by altmann Dec. 7, 2004, 06:43:59 PM EST
There is an osql
and a SET SHOWPLAN_TEXT (or SHOWPLAN_ALL)

MSDE (what I assume is meant by "runtime") should have the osql CLI tool. This could show whether the query has any problems when Access isn't in the way.

There's also a registry setting to turn plan logging on for the Jet engine that Access uses.

[link|http://builder.com.com/5100-6388-5064388.html|http://builder.com.c...6388-5064388.html]
--
Chris Altmann
Collapse All History
     Why does something this simple, take soo long? - (folkert) - (21) - Dec. 7, 2004, 02:27:17 PM EST
         Probably at the Access level - (JayMehaffey) - (1) - Dec. 7, 2004, 03:10:19 PM EST
             Doesn't matter either way. - (folkert) - Dec. 7, 2004, 05:37:39 PM EST
         Investigate Pass-Through Queries in Access -NT - (altmann) - (1) - Dec. 7, 2004, 04:35:46 PM EST
             Thanks. I do that later. - (folkert) - Dec. 7, 2004, 05:39:12 PM EST
         Latency between Access and SQL Server - (ben_tilly) - (2) - Dec. 7, 2004, 05:13:12 PM EST
             That is just WRONG. - (folkert) - Dec. 7, 2004, 05:40:00 PM EST
             Sometimes faster just to import the whole table - (ChrisR) - Dec. 7, 2004, 05:53:08 PM EST
         I would ask for a showplan - (Simon_Jester) - (1) - Dec. 7, 2004, 05:25:51 PM EST
             There is an osql - (altmann) - Dec. 7, 2004, 06:43:59 PM EST
         The answer is in the first line of your post -NT - (tuberculosis) - (1) - Aug. 21, 2007, 06:34:31 AM EDT
             Clever, cleaver, thine art. -NT - (folkert) - Dec. 8, 2004, 01:02:49 PM EST
         Most questions that start, "why does Access......?" - (tablizer) - (9) - Dec. 22, 2004, 05:17:20 PM EST
             That might change. - (inthane-chan) - (8) - Dec. 22, 2004, 05:38:40 PM EST
                 Not unless VB is integrated with SQL server - (ben_tilly) - (7) - Dec. 22, 2004, 06:28:24 PM EST
                     Yeesh! - (inthane-chan) - (4) - Dec. 22, 2004, 06:47:37 PM EST
                         That trick is actually useful..ugly, but useful -NT - (ben_tilly) - (3) - Dec. 22, 2004, 07:50:13 PM EST
                             The poor man's Control Tables -NT - (ChrisR) - (2) - Dec. 22, 2004, 07:57:27 PM EST
                                 That's one thing to use it for -NT - (ben_tilly) - Dec. 22, 2004, 08:40:28 PM EST
                                 Files systems are not much better. Trees too damned limited -NT - (tablizer) - Dec. 26, 2004, 03:24:20 AM EST
                     Perish the thought - (ChrisR) - Dec. 22, 2004, 07:06:12 PM EST
                     "In the Next Version" - (altmann) - Dec. 22, 2004, 08:01:26 PM EST

No, I am your father.
55 ms