Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

Hi

v10.0.1

When profiling a procedure I don't seem to be able to copy the line by line stats. You can get the procedure text but not the numbers. I wonder if they can be extracted from a system table?

(seem to have lost my OpenID!!)

asked 12 Mar '10, 17:21

Justin%20Willey%201's gravatar image

Justin Willey 1
11113
accept rate: 0%

Let me know if you want your old user id merged into your new one, carrying over points etcetera.

(12 Mar '10, 20:03) Breck Carter

Hi Breck - IF ITS EASY - could you merge the new account into my old one - I think I've now got a local password and don't have to authenticate using the ghastly Open_ID nonsense. Thanks Justin

(16 Mar '10, 18:06) Justin Willey

I'd like to offer a bounty on this - but I don't see the button. Its over 2 days old, but maybe 6 days is too old??

(18 Mar '10, 20:23) Justin Willey
Comment Text Removed

I've seen why I can't offer a bounty - I don't have enough reputation on this user account. Breck - could you go ahead and merge the accounts please? Many thanks

(30 Mar '10, 19:07) Justin Willey

In the help, under the index "procedure profiling" you'll find a reference to the sa_procedure_profile() system procedure, which does what you want - I think :-)

permanent link

answered 13 Mar '10, 14:50

Glenn%20Paulley's gravatar image

Glenn Paulley
10.8k577106
accept rate: 43%

Thanks Glen, that gives the performance by line number, but I think I then have to manually match up line numbers to the code. Unless I'm missing something there isn't anything that either gives me them together, or lets me retrieve from a system table what SQLA reckons is on each line of the procedure. Any pointers would be a help - it becomes an issue when trying to discuss a profiling result with somebody.

(16 Mar '10, 17:17) Justin Willey
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×276
×128

question asked: 12 Mar '10, 17:21

question was seen: 1,373 times

last updated: 13 Mar '10, 14:50