Are there any restrictions (theoretical or practical experience) on the number of simultaneously enabled web services (per one database/"-xs" server)?

asked 21 Sep '17, 08:31

Ilia63's gravatar image

Ilia63
1.2k515782
accept rate: 44%


There are no restrictions. Create as many web services as you want.

permanent link

answered 21 Sep '17, 08:35

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297
accept rate: 41%

I'd think as the SYSWEBSERVICE.service_id is an UNSIGNED INT, 2^32 - 1 would be a theoretical limit...:)

(21 Sep '17, 09:03) Volker Barth
Replies hidden

Thanks.
I think which of the two roads I should choose...
Or, I create a one "universal" web-service
that call the "universal" stored procedure
that will parse many different POST-requests and
call the stored procedure corresponding to the request.
Either I create hundreds of enabled web-services for each stored procedure (which is equivalent to “I am not sure that they did not pull me into a hundred little bearlings ...” (c) Baloo).

(22 Sep '17, 06:29) Ilia63
Comment Text Removed

One approach is to create CREATE SERVICE and CREATE PROCEDURE in pairs, using the same name for each, and storing them in the same *.sql file.

In a simpler world, the syntax would be combined... but the world is not simple, and sometimes services have aliases like "root".

IMO "universal" services and procedures will make your life more difficult, similar to a "universal code table" folks sometimes use instead of creating a hundred separate tables... both performance and especially maintenance suffers because of the unnecessary complexity AND the inevitable compromises when the "universal" structure doesn't accomodate special cases without blunt hacks.

(22 Sep '17, 08:37) Breck Carter
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:

×438
×260

question asked: 21 Sep '17, 08:31

question was seen: 1,457 times

last updated: 22 Sep '17, 08:37