Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Large Number of Users - Potential Problems

3 posts in replicator Last posting was on 2007-02-02 14:09:28.0Z
Robin Posted on 2007-02-02 13:06:38.0Z
Sender: 5043.45c0e652.1804289383@sybase.com
From: Robin@RobinStClair.com
Newsgroups: sybase.public.ase.replicator
Subject: Large Number of Users - Potential Problems
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <45c3456e.79bc.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Feb 2007 06:06:38 -0700
X-Trace: forums-1-dub 1170425198 10.22.241.41 (2 Feb 2007 06:06:38 -0700)
X-Original-Trace: 2 Feb 2007 06:06:38 -0700, 10.22.241.41
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:165
Article PK: 103370

I am currently modelling and trialling a database which will
potentially be used by up to 100,000 different users.

As you might expect, it will be clustered and replicated to
other sites.

I would be grateful if anybody could advise me as to whether
I should use custom user entities or whether the normal
system tables are suitable for a large number of different
users.

Whilst the vast majority of the users will have the same
rights and be in the same user group, there is a need to
trace the actions of each individual user.

Any informed advice on this matter would be appreciated, I
would prefer not to have to modify this aspect of the
architecture at a later date.

Robin


Jason L. Froebe [TeamSybase] Posted on 2007-02-02 13:18:13.0Z
From: "Jason L. Froebe [TeamSybase]" <jason@froebe.net>
Organization: TeamSybase
User-Agent: Thunderbird 1.5.0.9 (X11/20070103)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.replicator
Subject: Re: Large Number of Users - Potential Problems
References: <45c3456e.79bc.1681692777@sybase.com>
In-Reply-To: <45c3456e.79bc.1681692777@sybase.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: c-24-14-200-200.hsd1.il.comcast.net
X-Original-NNTP-Posting-Host: c-24-14-200-200.hsd1.il.comcast.net
Message-ID: <45c34825$1@forums-1-dub>
Date: 2 Feb 2007 06:18:13 -0700
X-Trace: forums-1-dub 1170425893 24.14.200.200 (2 Feb 2007 06:18:13 -0700)
X-Original-Trace: 2 Feb 2007 06:18:13 -0700, c-24-14-200-200.hsd1.il.comcast.net
Lines: 47
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:167
Article PK: 103372


Robin@RobinStClair.com wrote:
> I am currently modelling and trialling a database which will
> potentially be used by up to 100,000 different users.
>
> As you might expect, it will be clustered and replicated to
> other sites.
>
> I would be grateful if anybody could advise me as to whether
> I should use custom user entities or whether the normal
> system tables are suitable for a large number of different
> users.
>
> Whilst the vast majority of the users will have the same
> rights and be in the same user group, there is a need to
> trace the actions of each individual user.
>
> Any informed advice on this matter would be appreciated, I
> would prefer not to have to modify this aspect of the
> architecture at a later date.
>
> Robin

Hi Robin,

If you are talking about ASE 12.5.x or 15.x, yes, the system tables can
handle the load (set up multiple tempdbs for starters).

As for the whether an 'application login' would be useful or not really
depends on your business requirements. In short, there isn't a
technical reason to do so.

For ease of user administration, an application login would make sense
though.

"Six of one, half dozen of the other"

--
Jason L. Froebe

Help find a cure for breast cancer! Net proceeds benefit the Susan G.
Komen Breast Cancer Foundation and the National Philanthropic Trust.
Help by donating at http://www.the3day.org/chicago07/jfroebe - I'm
walking 60 miles in 3 days in August 2007. (The day I return from
TechWave is the first day of the Walk)

WebBlog http://jfroebe.livejournal.com
Tech log http://www.froebe.net/blog


Robin Posted on 2007-02-02 14:09:28.0Z
Sender: 5043.45c0e652.1804289383@sybase.com
From: Robin@RobinStClair.com
Newsgroups: sybase.public.ase.replicator
Subject: Re: Large Number of Users - Potential Problems
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <45c35428.7b15.1681692777@sybase.com>
References: <45c34825$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Feb 2007 07:09:28 -0700
X-Trace: forums-1-dub 1170428968 10.22.241.41 (2 Feb 2007 07:09:28 -0700)
X-Original-Trace: 2 Feb 2007 07:09:28 -0700, 10.22.241.41
Lines: 45
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.replicator:170
Article PK: 103376

Jason

I can see that I am going to have to come up with some kind
of 'integrated' login. I expect all workstations will
require biometric/physical security devices tied to each
user in the immediate future, so it makes more sense to
build on this foundation.

I expect to deploy 15.x, so I am relieved to hear that you
feel the system tables are up to the task.

Thanks for your response.

Robin

>
> Hi Robin,
>
> If you are talking about ASE 12.5.x or 15.x, yes, the
> system tables can handle the load (set up multiple
> tempdbs for starters).
>
> As for the whether an 'application login' would be useful
> or not really depends on your business requirements. In
> short, there isn't a technical reason to do so.
>
> For ease of user administration, an application login
> would make sense though.
>
> "Six of one, half dozen of the other"
>
> --
> Jason L. Froebe
>
> Help find a cure for breast cancer! Net proceeds benefit
> the Susan G. Komen Breast Cancer Foundation and the
> National Philanthropic Trust. Help by donating at
> http://www.the3day.org/chicago07/jfroebe - I'm walking 60
> miles in 3 days in August 2007. (The day I return from
> TechWave is the first day of the Walk)
>
> WebBlog http://jfroebe.livejournal.com
> Tech log http://www.froebe.net/blog