May 18, 2009 at 1:43 pm
You could try using connection pooling from web server side to manage these many users.
May 19, 2009 at 7:42 am
Forgive me if I'm stating the obvious, but I suspect this was an interview question/homework assignment rather than a "real" problem.
May 19, 2009 at 7:45 am
I don't know what the OPs problem truly is. But I will say that anything that needs a scale of 30M had better be designed and programmed and maintained by a TEAM of VERY competent specialists. You have no hope of success on a project of this magnitude asking the questions you are asking. That isn't a personal attack, btw, just the best advice I can give.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 19, 2009 at 7:50 am
Chris (5/19/2009)
Forgive me if I'm stating the obvious, but I suspect this was an interview question/homework assignment rather than a "real" problem.
I almost hope it is.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2009 at 7:53 am
GilaMonster (5/19/2009)
Chris (5/19/2009)
Forgive me if I'm stating the obvious, but I suspect this was an interview question/homework assignment rather than a "real" problem.I almost hope it is.
I wish it wasn't - and I got to work on the project! :-))
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 19, 2009 at 7:54 am
linhdkl (5/18/2009)
and now i find the solution for this problems, it is using Partitioned Tables and Indexes.it's very very simple .... because I don't want anything more than a solution (other words you can call it's an idea). :w00t:
Partitioned tables, properly designed, will help on a large database, but they are by no means a silver bullet or a solution to all scalability problems. Indexes, properly designed, will help performance if the queries are written in such a way as to use them.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2009 at 7:58 am
TheSQLGuru (5/19/2009)
GilaMonster (5/19/2009)
Chris (5/19/2009)
Forgive me if I'm stating the obvious, but I suspect this was an interview question/homework assignment rather than a "real" problem.I almost hope it is.
I wish it wasn't - and I got to work on the project! :-))
I dunno. This smells (if it is a real project) of train wreck in progress.
Work on it in the beginning - design and setup, yes. Work on it later, fixing all the mess ups, maybe not.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2009 at 9:20 am
As an independent consultant (and knowing that you are newly so), let me paraphrase Robert Duvall in "Apocalypse Now": I love the smell of a train wreck in the morning . . . it smells like . . . MONEY!! 😎
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 19, 2009 at 10:51 am
TheSQLGuru (5/19/2009)
As an independent consultant (and knowing that you are newly so), let me paraphrase Robert Duvall in "Apocalypse Now": I love the smell of a train wreck in the morning . . . it smells like . . . MONEY!! 😎
and if it's urgent ... it smells like a blanc cheque 😛
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 9 posts - 16 through 23 (of 23 total)
You must be logged in to reply to this topic. Login to reply