Queuing Using The Database Or MSMQ?
Mar 23, 2010
A part of the application I'm working on is an swf that shows a test with some 80 questions. Each question is saved in SQL Server through WebORB and ASP.NET. If a candidate finishes the test, the session needs to be validated. The problem is that sometimes 350 candidates finish their test at the same moment, and the CPU on the web server and SQL Server explodes (350 validations concurrently).Now, how should I implement queuing here? In the database, there's a table that has a record for each session. One column holds the status. 1 is finished, 2 is validated.
I could implement queuing in two ways (as I see it, maybe you have other propositions):A process that checks the table for records with status 1. If it finds one, it validates the session. So, sessions are validated one after one.
If a candidate finishes its session, a message is sent to a MSMQ queue. Another process listens to the queue and validates sessions one after one.Now:What would be the best approach?Where do you start the process that will validate sessions? In your global.asax (application_start)? As a windows service? As an exe on the root of the website that is started in application_start?To me, using the table and looking for records with status 1 seems the easiest way.
View 3 Replies
Similar Messages:
Oct 28, 2010
I'm putting together a web app that will process time consuming jobs in the background.so for example 100 users are on the site 20 of them submit jobs to the server. these 20 jobs get added to a list and the background worker pickes them up one by one. I want to be able to have up to 10 background workers doing the tasks.
for scaleability the job list is likely to be a database table, however at the proof of concept stage I will probably use an application variable (stack of some sort) with a GUID to identify each job.
So I *think* what I need is ....
a single background worker process that starts when the web app starts.This process monitors the stack / job list. It dynamically creates a worker process for the first item, removes the job from the stack and increments the thread count.If there is a second job it creates another thread (up to 10) and increments the thread counter.When each thread finishes it closes itself and decrements the thread count.
If I move to the database table job list would it be better to have ASP.Net add jobs and a windows service do the processing?
View 8 Replies
Dec 13, 2010
We have one application, which have to store multiple emails in the msmq and pass to different application...so please tell me how to implementt msmq in .net?
View 1 Replies
Dec 13, 2010
We want to implement MSMQ in windows 2007, is it possible? tell me the prerequisites for MSMSQ?
View 1 Replies
Oct 31, 2010
I have a Web App and a service sitting on the same machine and communicating via message queues. The problem I'm experiencing is that about half of the time the messages I send from the service are not arriving to the reading code in the web app. Some of them will arrive and some will not. The messages are sent with at least 1 second delay between them.
To make things harder - I don't see ANY of my messages in the management console, even those that do arrive. I turned journaling on, but see no difference. I have full access to the queue.
The reading code looks like this:
public SomeMethod
{
...
MessageQueue respQ = Utils.GetResponseQueue();[code]....
View 1 Replies
Jan 11, 2010
I am have made a website which entertains its users(authenticated) to send sms. Website is available to users within my local network and outside (internet). I have designed two libraries, one for sending receiving sms and other one for processing those sms messages....But whenever page is refreshed, all the objects are initialized again blah blah resulting error for port 'Acess denied' For that I used object serialization etc. But I want to put my whole sms related work to separate process and use MSMQ between my website and sms process for communication. Please guide me that how can I run that separate sms process all the time and taking commands from website to send sms to whom etc?
Requirements:
1. SMS Process (background) should not have any interface but to communicate with using MSMQ only.
2. Website should be able to communicate with that SMS Process at any time using MSMQ, that is commands to send sms to whom, show received sms etc.
I am complete with all my website and sms engine work. All put all this in website but couldnt get reliablility. Please just guide me how and where to start for MSQM?
View 1 Replies
Apr 6, 2010
I'm seeing a really strange error that I'm having a difficult timetracking down. I think its related to my configuration of Rhino ESB, though I'm not sure
if RSB is actually causing it, so I figured I'd ask and see ifanyone else has come across this in any other usages of MSMQ.I'm using RSB as a client in a web app (ASP.NET, the client runs in the background). The client talks to a windows service via the MSMQ binding for RSB. Restarting the service never appears to have an effect on MSMQ, neither does restarting IIS by hand. However, whenever I actually restart the computer itself, MSMQ always refuses to start back up, claiming that a "queue is in an inconsistent state". Attempting to start MSMQ manually results in the same error, effectively rendering the MSMQ install completely useless. The only way to solve it is to actually remove then reinstall MSMQ.
The only information I've found via the almighty Google are references to a problem in MSMQ 2.0 (this problem is occurring in MSMQ 4.0). I've verified that Dispose is being called on on the bus at shutdown, in both the service and the web site.
View 1 Replies
Dec 31, 2010
I am working on live trading system, in this web system i have to show live data so i am calling my store procedure for bind my data. I have few questions -
Is it possible to use MSMQ in web ?
Is it possible to use socket programming in web ?
Its because i am calling SP in every 5 seconds and its very lengthy. I want to use socket programming or MSMQ in LIVE trading system because if any thing update or modify in tables then only web page get notification from MSMQ or Socket and i will bind my page then only. And if possible then its secure and perfect for web live environment ?
View 8 Replies
Apr 12, 2010
To meet the needs of a colleague, I must get plian text into a MSMQ message queue. Trouble is, Sytem.Messaging results in a body wich defaults to xml content. I had thoght that this would get round the problem - but it doesn't:
[Code]....
The body content looks rather strange actually - it reads:
54 65 73 74 20 54 65 78 Test Tex
74 20 4D 65 73 73 61 67 t Messag
65 e
Any thoughts on how to get rid of all those numbers and just have a plain text body?
View 4 Replies
Jun 14, 2010
I was just wondering if anyone has ever had to port the schema across? Are there any experts that could pitch their opinions on the achievability of this (mad) idea? I'm using the IBM Migration Toolkit and as expected its throwing a bunch of translation errors some of which were relatively easy to solve (vendor specific function calls for example) and some will take quite a while to pin down and work round.... however this is not my main concern.
If completed I expect I am going to have to basically rework all the System.Web.Profile/Roles/Membership namespace classes etc to work round the SQL limitations of informix (i.e. IDS11.x SQL server doesnt have a DEFAULT (newguid()) so that would have to be put into the calling method) (and any MVP comments really as I can slap my boss round with the weight after he ludicrously agreed to this project for a client without doing any research...)
View 1 Replies
Jul 29, 2010
you could create your own custom Profile provider that operates against existing database tables .i want u to help me out if u have an idea where i can get steps by steps to carry out the above operation.i know there are various options in creating profile , particularlly the use of web. configuration, the default ASPNETDB, and XML files, BUT i wish to use an existing database which i prefer.
View 11 Replies
Feb 23, 2011
I have a aspxtextbox and its validated from database.If text exists in database then it shows message Username exist.Now this is all happens on click of a aspxbutton after typing some text into aspxtextbox.I just want that when user defocus the textbox then it will automatically check from database and shows the message if exists.
View 1 Replies
Oct 6, 2010
I m trying to save files like pdf, word, excel etc... into sql express, but m getting this error in my web page:An attempt to attach an auto-named database for file C:Usersmalek.safaDocuments est vbSavingFileInDBSavingFileInDBApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
m not getting errors inside my code, just this one appearing on the web page.
View 2 Replies
Mar 2, 2010
I'm trying to figure out if it's possible to transfer records from SQL central database (who has a public IP address) into SQL local database (who doesn't have a public IP)?
or if it's not possible can I use a centralized website instead to pass some data into the local website? (but i'm not sure if it will have some security concerns)..
View 3 Replies
Nov 6, 2010
how can i store youtube or any other video URL or link in database and retrive from database
and what control i use in this in C sharp
View 5 Replies
Aug 4, 2010
when make buakup to my data base and open the database digram this error appear : Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
View 1 Replies
Aug 3, 2010
I have several web sequential pages which will modify a record and its child records in the database, called a "project". Such a project is currently passed between pages using its database ID in the URL parameters.
A project has some information specific to itself, and also consists of one or more Tasks, which each have information specific to itself.
Is it faster (alternatively, more maintainable or more easily understood) to hit the database each time I need to query the same project (and its tasks), or should I query the database once (either once for each page or once for all pages and save to Session) and check the saved object rather than the database?
View 2 Replies
Jan 8, 2010
I am trying to generate a Grid view from database, in one of my database columns the values are 'y' and 'N'. and i need to show this values in a check box .I tried to keep a check box in item template and tried to bind it, but could get much success.
[Code]....
View 6 Replies
Jan 22, 2010
Creating a system with web front end and SQL backend (microsoft obviously). I have tried using the asp.netsqlprovider but i can;t as i am only allowed one database on the server, so i then tried to update my current database with the triggers to input the schema into the already existing database.Next step i create my own table with two simple fields of username and password and try and authenticate that way, i can't get that to work either.
I ahve limited permissions on the network as i am a University Student. I really don't know what to do. Never had to create a log on system before and i thought it would be far simpler than this. I ahve used Microsoft's sqlprovider schema before and it worked fine. I have also authenticated via IIS and AD too before. I can't do any of those two in this instance it seems.I need an alternative for logging in users, if needs be in can be crude. I also still need to have some kind of two different views too for logged in users and not logged in users, but that can change if needs must.Don't let me down people, haha. Think this posts in the correct place, i could not find another one i thought could be more relevant.
View 4 Replies
Mar 1, 2011
how I can correct an error. I've built the MVCMusicStore tutorial here:
http://mike-ciccone.com/Store/
The first time I visit the site and attempt a database connection I get this error:
Exception Details: System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database 'master'.
But when I refresh, it all works fine. I'm at a bit of a loss. I don't believe I'm attempting to create a database, but I realise that the error may not really have anything to do with that. This is hosted at GoDaddy shared hosting. The database was created and I used an SQL script to create the tables initially and populate the data. My connection string works as I can pull data from the database, but I do have
a feeling it will be a web.config setting that will correct this.
View 3 Replies
Feb 23, 2010
For the login control that I am using, there is a connectionstring which is automatically created in the web.config file.I ran an .exe file which populated the specified database with all the asp login related tables and stored procedures...
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=localmachineName;Initial Catalog=DBName;Persist Security Info=True;User ID=DBUserName;Password=password" providerName="System.Data.SqlClient"/>
How can I point the login control to a different Database based on the database selection by a user i.e. the user can change the name of the database and so the login should point to that database.
View 7 Replies
Aug 31, 2010
i am trying to restore database.bak in sql server 2005 (i know the database.bak was also generated in sql 2005 server)
i am trying to restore back up database .bak into the new database i just created in sql server 2005i have saved my database .bak into c drive and when i select database .bak "From Device", it doesn't get populated in the list below and i see nothing and it keeps on prompting a message"You must select a restore source"
Here's the screen shot: (i tried restoring database in sql server 2008 and it was sucessful but i am facing this problem in sql server 2005 only)
View 4 Replies
May 10, 2010
I have some data which is in mySQL, i am not familier with mySQL, i would like to transfer all the data from MySQL to SQL Server database,
View 11 Replies
Mar 24, 2011
then the database table is created in database(that is SQL express),how can do that.Please sir help me in that problem.I try that thing and debug the code and there is no error in the code but when I click the button in run time ,no table is created in the database(which is placed in sql express 2005).So my problem is that why the table is not created in the database.
[code]...
View 3 Replies
Mar 20, 2011
My question is that if the user click on button (which is place in default.aspx, for example) then the database table is created in database (SQL express), how can do that? I have tried but errors are occuring during debugging, errors are:the best overloaded method match for 'system.data.odbc.odbc command.odbc command(string,system.data.odbc.odbc connection)'has some invalid arguments.
Argument'2':cannot convert from 'system.data.sqlclient.sqlconnection' to 'system.data.odbc.odbc connection'.
The code written in c# behind the button (button is placed in default.aspx, for example) is:
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
[code]...
View 2 Replies
