Database concurrency
-
Hi professionals, I am a begginer in web programming and this question just popped in my head. If I am to design a website that serves thousands of users conccurrently, let's say a forum, let us assume that we have infinite server bandwidth and storage capacity, are there any considerations I should take into account when designing my website, for example what is the effect of the following points on concurrency and performance of the database: 1. Choosing between different database engines (JET, Oracle, MySQL, SQL Server...) 2. Optimizing the SQL Query. 3. Are there any techniques that I should follow in my C# code-behined to improve oncurrency? what are they (if any)? 4. Any other things to consider? Thank you very much Mohammad
And ever has it been that love knows not its own depth until the hour of separation
-
Hi professionals, I am a begginer in web programming and this question just popped in my head. If I am to design a website that serves thousands of users conccurrently, let's say a forum, let us assume that we have infinite server bandwidth and storage capacity, are there any considerations I should take into account when designing my website, for example what is the effect of the following points on concurrency and performance of the database: 1. Choosing between different database engines (JET, Oracle, MySQL, SQL Server...) 2. Optimizing the SQL Query. 3. Are there any techniques that I should follow in my C# code-behined to improve oncurrency? what are they (if any)? 4. Any other things to consider? Thank you very much Mohammad
And ever has it been that love knows not its own depth until the hour of separation
Mohammad A Gdeisat wrote:
Any other things to consider?
1 - A perfectly layered architecture would give easy solutions for maintaining your application. 2 - Understanding which operations are costly and, using right controls and data access classes. 3 - Proper caching of your data. 4 - Disabling viewstates on the pages which doesn't require postback 5 - Indexing the tables 6 - Designing the pages with DIV and CSS instead of using tables. and many more
All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions
-
Hi professionals, I am a begginer in web programming and this question just popped in my head. If I am to design a website that serves thousands of users conccurrently, let's say a forum, let us assume that we have infinite server bandwidth and storage capacity, are there any considerations I should take into account when designing my website, for example what is the effect of the following points on concurrency and performance of the database: 1. Choosing between different database engines (JET, Oracle, MySQL, SQL Server...) 2. Optimizing the SQL Query. 3. Are there any techniques that I should follow in my C# code-behined to improve oncurrency? what are they (if any)? 4. Any other things to consider? Thank you very much Mohammad
And ever has it been that love knows not its own depth until the hour of separation
Since u r a biggener, don't fly so high just make an simple start and think about such terms when u get some experience. i doesn't demotivate u but it is just an suggetion for u . Thx
manoj Kumar Jha "Learn to smile at every situation. See it as an opportunity to prove your strength and ability."
-
Since u r a biggener, don't fly so high just make an simple start and think about such terms when u get some experience. i doesn't demotivate u but it is just an suggetion for u . Thx
manoj Kumar Jha "Learn to smile at every situation. See it as an opportunity to prove your strength and ability."
-
Stop using text speak. Please read the forum guidelines.