Architecture :: Very Frequent Reads To Database Multiple Clients?
Dec 5, 2010
I have a website hosted with sql 2008 database on Godaddy. Here's my problem descriptionbefore I actually begin implementing.Entries are made in a table named "XYZ" by a third party program. Now, there are multipleclients (could be asp.net ajax web based or vb.net desktop clients which I have not decided yet) who
read data from this "XYZ" table every 10-15 seconds. The connection string used by these clients would be same. If I have 10000-20000 clients making connections and querying same table, would that cause any breakdown? Since my connection string is same, connection pooling isautomatically in place.
What else do you think I need to take care of? Or is there any better way to implement this setup?Also, should I go for asp.net ajax client implementation or vb.net(c#) client implemtation ?Your inputs would be highly helpful to me. I am looking for a medium to long term solution to thissetup.
View 10 Replies
Similar Messages:
Dec 9, 2010
Imagine a website where individual clients can see each-other's presence - like a social network or a chatroom.
For example:
Client1 connects to my website.The back-end C# code updates a static field to indicate Client1's presence.
Client2 connects to my website.Will the back-end C# code for the second request see the information stored in the static field from the first request? Is there anything I need to do to guarantee that these seperate instances of my ASP application are sharing static data?
View 4 Replies
Nov 4, 2010
i have an Asp.net application 3.5. I want to be able to allow multiple/ different clients to access the same application but using different url's. I have already managed to configure the database to allow this. So hia's the main part i want to host my application in a domain say... wwww.myapplication.com
then allow different client to access the same application using
1.www.clientOne.myapplication.com
2.www.clientTwo.myapplication.com
also the client subdomains i.e(clientone.myapplication.com and clienttwo.myapplication.com)should be autocreated by the client upon registration
View 5 Replies
Feb 4, 2010
How can I make multiple Index pages (contains a list of data), one to be used for a regular client, and one special view for the iPhone. Based on the article found on http://dotnetslackers.com/articles/aspnet/DevelopingForTheiPhone.aspx , I know that I can distinguish using
[Code]....
View 1 Replies
Dec 21, 2010
So I have the following requirement for a project I'm working on, and I can't figure out the best (or any, for that matter) way to do this.
I have an asp.net web app sitting on IIS at HQ. When a particular event occurs, I need to then show a message on a dynamically selected subset of PC's throughout the company. The message must be shown due to the time restraints of this process (4 hours reaction time) and we legally can't afford to not show the message.
So I need to do the following:
Show a message to the users. I have a winforms app that puts up a dialog that the only way to get rid of it is to click a big "Acknowledge" button. To ensure that the message was shown. Some kind of report back that yes, it was shown and subsequently acknowledged. A way to react if the form is not shown.
I've considered the following:
PsExec - Iterating over every node asynchronously in my web app to fire off a remote executable sitting on each PC. .NET Remoting - I'm not familiar with this at all, and it lead me to look at WCF instead. Would it work for what I'm trying to do? WCF Callbacks - These seem to require a constant connection and I'm not sure what that means for our infrastucture. I imagined a client service that would kick off an app or show the form somehow. Our scheduling software (Tidal Enterprise Scheduler) - remotely executing an executable. This would introduce more points of failure.
In SO's opinion, what would be the best way to attack this problem?
View 3 Replies
Feb 15, 2011
First of all, I am creating a something like a client/server solution using a standard ASP.NET website - I do know this method is not adviced, and most people would love to scream "COMET!" or "HTML5 Sockets!" - but please don't ;-) !
What I am doing...
I am creating an MMORPG on a website.
I have several clients whom need to be in contact at the same time. This is done by a global object in the Application scope.
My problem
I need to invoke an event to several clients. For instance, when an attack has been performed, I need to update some graphics. The attack logic is resolved in the global object, but each of the clients has to respond to this.
Right now I do the following:
fightTrace.Reciever.InvokeMoveEnded(this);
fightTrace.FiredBy.InvokeMoveEnded(this);
(This is a kind of observer pattern)
What now happends is a race condition. The one who loads the page_load event will get both of these events, and the one who is not running them, will experience no changes in the UI.
So what is it I really want?
What I really need is some genuine and nice way to create an observer pattern through the application state. I need to send an event out to every "listener" which is in this case is a client, and then do some update.
View 1 Replies
Sep 21, 2010
How can i send email to multiple clients located in different domains such hotmail,yahoo,and gmail
is it required to provide Smpt server name, if we have multipe domain id, what should we do?
I am using fowling code but getting exception failed.
MailMessage mailMsg = new MailMessage();
mailMsg .From = "from@fromServer.com";
mailMsg .To = "to@toServer.com";
mailMsg .Cc = "cc@ccServer.com"";
mailMsg .Bcc = "bcc@bccServer.com";
mailMsg .Subject = "SubjectOfTheMailString";
mailMsg .Body = "BodyOfTheMailString";
SmtpMail.Send(mailMsg );
View 2 Replies
Apr 27, 2016
I'm trying to develop a new application for multiple users. the main idea is that one user talks and the entire users (who logged in ) could hear him (1 way).
How this can be made? how can i transfer voice from one client to multiple clients in live?
Note that my clients are mobile users (Android, IOS and Windows phone) and the server is .NET.
View 1 Replies
Apr 26, 2015
I am adding new clients to a database using ASP.net I want to check if the username the client has chosen is not already in use by another client and highlight the relevant input box and write a message to select a different user name if it is.
Is there way to write to a specific place in the HTML similar to innerHTM? I haven't been able to find such. Alternatively i guess I could try an interact with client side Java, or re-write the whole page.
View 8 Replies
Apr 13, 2010
I have been banging my head against this problem for a bit and I think I am stuck. I would like to pull data from a Database to populate a list of possible "clients" to select from on one side. Then using what has been clicked load the client specific data into a tab container on the opposite side. I plan on doing lazy tab loading so I am not sure if that matters. I am really stuck and any help or guidance anyone could give would be greatly appreciated! I understand the basics of data loading and of tab containers, but i am unsure of what to do. I am coding this in C#. Example Mock Interface This is where the data list would be and I want to be able to select something here And update the Tab Panel control here based on the selection from the left side via querying the database.
View 3 Replies
Dec 6, 2010
I'm trying to figure out how to write this in LINQ.
Lets say I have a table of book reviews. Each book has a rating of 1 to 5. At the moment I am getting all book reviews by a bookID. I want to then say "Get the score that occurs most frequently for those given reviews". So if Book1 has reviews of 1, 1, 2, and 4, the statement would return 1. If Book1 has reviews of 1, 2, 2, 4, it would return 2.
View 1 Replies
Nov 4, 2010
Am using Lucene.net 3.0 in my Application which as frequent updates to index.
But when new data on a forum it's not available in the search . it's taking few minutes to update index.
how can i overcome this.....
View 1 Replies
Jan 25, 2010
I made a function that sends emails to some members or subscribers , lets assume the email is a birthday greeting, if today is the member's birthday the system will send himher a greeting.The question is: How can I call or trigger this function everyday at a specific time automaticly !? The website uses .net Framework 3.5 & published on IIS6 .
View 2 Replies
Oct 29, 2010
I receive lists from a web service and then I convert the lists to datatable and then I add the datatables to a dataset and from there I get the xml from the dataset where I can save it into a sql database. But the problem is that the xml has /r/n between all attributes and elements. I dont know how to get this out of the xml. Can this be because of my converter. If so can anyone give me a better way to get multiple lists into a dataset.
View 2 Replies
Apr 13, 2010
I am having serious performances issues with gridview + tabs. Its very slow.. I was thinking to create a XML based logical layer between my database and UI.
1) Will it be useful if i use webservice to get data from database to poppulate gridview?
2) or Use xml + some service (need advice on it)
View 3 Replies
Nov 22, 2010
I am trying to find a code snippet that reads a sql server db and retrieves an image from a table and converts it into a thumbnail image. I'm looking for VB.Net code that does this and I can't find anything.
View 23 Replies
Sep 13, 2012
I have a dropdown on my page that reads a value from the users session.
ddlMemberGender.SelectedValue = Session("MemberGender")
there are two choices (obviously) : Man and Woman
So when the Session value sets the DropDown to Male it works fine. But if the user changes the DropDown to Woman in my code behind it still reads "Male" as the value... for example:
Response.Redirect("/post.aspx?Gender=" + ddlSearchMemberGender.SelectedValue) will still read the selected value that was set previously instead of the value it was changed to.
View 2 Replies
Feb 12, 2010
I have been creating my BLL and DAL with in the same project as my UI. These have been logical tiers in their own folder with in the same project, that's with in the same solution. I want to try to create a solution that is more like a truly multi tiered app.
I've heard people talk about using a separate projects for their DAL and BLL. My understanding is that these would be separate dlls that would contain the appropriate code for each of the these tiers. I have a few questions regarding this.
Is this a good way to do this? It seems like a logical approach. It also seems like the next step in me moving towards an architecture that's truly tiered. Should I do this differently?
Should the projects for the BLL and the DAL use the same namespace? I think I read that some people use a namespace for each of these that indicates what they are, such as BLL and DAL.
View 6 Replies
May 5, 2010
I have couple of DDL's which let user choose couple of different values from it. Once the user has made his selection he clicks on the "Submit" buttion which redirects the user to the other page, which then displays table from backend SQL DB. The pages are named Page1.aspx and Page2.aspx resp. I am using Querystring to carry forward the values of the DDL's to Page2.aspx.
How can i modify the query in such a way that even if one of the DDL's is left blank the Query would ignore that and shall produce the table considering value of DDL2 in the where clause. In case both the DDL's are empty then the query will not have a where clause and shall showcase the complete table as such. I've written a query for this but it's not working the way it shoul.Here is my code for the SQLDataSource: [Code]....
View 3 Replies
Nov 22, 2010
I've developed a flash utility for a game portal that i'm building. The swf reads an xml file that contains the most played games. It works on the laptop but in the website
View 1 Replies
Jan 24, 2011
I have a page in a structure as follows. But the loading time of the page is takes 20 or more seconds. In usercontrols i'd used Telerik RadControls, for that reason i can't use updatepanel to avoid script problems or etc. I had tried to add usercontrols dynamically but there is about 14 usercontrols and it takes the same time period :(. I had tried using PartialUpdatePanel as in [URL] but it's not compatible with telerik controls. My client wants to have the all 14 usercontrols being in the same page (not divided by tabs or wizards)
Structure :
MasterPage
Page
14 Usercontrols that contains RadListViews has couple postback events.
View 5 Replies
Feb 2, 2010
I'm trying to define a computed column that will contain an auto-incremented number. In other words, I want it to work exactly like identity, but since I can have only one identity column per table, I wanted to make a computed column that reads its latest value and increment it by 1.
View 5 Replies
Sep 17, 2010
I am supposed to develop an enterprise-class ASP.NET Web Application that connects to multiple databases. For example when the web form loads, I should populate different ASP.NET controls (GridView, DataPager, TextBox, DropdownList etc) from multiple databases (SQL Server, Oracle, DB2, SAP Server etc) and also, edit the data in the controls and save the data to the respective databases on button submit.
Should I use Web Service or WCF for data integration, if so is there a limit on the size of the data?
What should be the architecture considering the application should be scalable and easy to maintain?
View 2 Replies
Mar 27, 2010
I recently received a project that contains multiple web applications with no MVC structure. For starters I've created a library (DLL) that will contain the main Business Logic. The problem is with Caching - If I use the current web context cache object than I might end up with duplicate caching (as the web context will be different for every application).
I'm currently thinking about implementing a simple caching mechanism with a singleton pattern that will allow the different web sites (aka different application domains) to share their "caching wisdom". I'd like to know what is the best way to solve this problem.
View 3 Replies
Nov 19, 2010
What is the reason that mulitple inheritance is not allowed in .net.
View 2 Replies
