Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

This forum has been exhibiting inconsistent and often quite slow response times lately... machine response, not human response (although some questions have been a challenge recently :)

asked 11 Sep '13, 16:55

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050
accept rate: 20%

Fully agree - particularly on the comment in brackets:)

(12 Sep '13, 03:40) Volker Barth

Unfortunately, the "search" has always been very slow.

permanent link

answered 16 Sep '13, 11:10

LGregianin's gravatar image

LGregianin
27661320
accept rate: 40%

1

...and that's why we have Google, or more specifically Google the SQL Anywhere forum.

Also see Searching for SQL.

(16 Sep '13, 15:31) Breck Carter

Yes it has. I've noticed this since we recovered from the outage last week. I've been busy with other stuff but I did briefly try to investigate and saw no problems - the database server seems fine and responsive. Could be a problem with Apache, or a problem with the VM, or a problem with the SAP network, or something else. I will continue to look at it.

permanent link

answered 11 Sep '13, 17:02

Graeme%20Perrow's gravatar image

Graeme Perrow
9.6k379124
accept rate: 54%

It seems faster today!

(12 Sep '13, 11:00) Derli Marcochi
Replies hidden

I found a couple of database connections that seemed to have been orphaned. They were processing something, and had been for more than a day, but I couldn't tell where they came from; it seemed like the client that started them had gone away but Apache hadn't killed the associated database connections. I dropped those connections and things have been much better since. I'm 99% sure that these connections weren't there the first time I looked but perhaps I missed them.

(12 Sep '13, 14:57) Graeme Perrow
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:

×178

question asked: 11 Sep '13, 16:55

question was seen: 2,166 times

last updated: 16 Sep '13, 15:31