msmq - Can someone tell me if SQL Server Service Broker is needed for this scenario? -

-

my first ever question on stack overflow please go easy. have long running windows application continually processes sql server commands. have web front end users use use update same db. i've noticed (depending on windows application processing @ time) if user submits db receive out of memory exceptions on server. realise need dig around bit more , optimise code. cannot afford server go down , expect in future i'll allowing more , more users on frontend. need system queue users requests (they not time critical) , process them when db ready.

i'm using sql 2012 express.

is sql service broker best solution, i've looked msmq.

if can point me in right direction appreciate. in search i'm finding lot of things don't think need.

cheers

it depends on you're doing persistence work, , / or calculations. if you're doing hard work in windows application, using service broker queue won't worthwhile, doing receiving message service broker queue in windows application, doing calculations , / or queries windows application, , persisting results database: database under memory pressure, seems unnecessary load queue , retrieve message msmq (or other queueing technology).

if doing work in database , windows application acts marshalling service - eg taking request , palming off stored procedure actioning - service broker queues may worth using: because operating within context of database, can efficient @ persisting amd querying data.

you want take failure modes, depending on whether or not can afford lose messages. ensure message persistence in msmq have use transactional messaging: service broker more efficient @ transactional queue processing msmq (because has transaction support built in, unlike msmq has use dtc, adds overhead) - if volume of messages low, may not issue.


Comments

Post a Comment

Popular posts from this blog

c++ - OpenCV Error: Assertion failed <scn == 3 ::scn == 4> in unknown function, -

-
i read alot other solution still confused should mine... #include <opencv2/objdetect/objdetect.hpp> #include <opencv2/highgui/highgui.hpp> #include <opencv2/imgproc/imgproc.hpp> #include <iostream> #include <stdio.h> using namespace std; using namespace cv; int main(int argc, const char** argv) { //create cascade classifier object used face detection cascadeclassifier face_cascade; //use haarcascade_frontalface_alt.xml library face_cascade.load("haarcascade_frontalface_alt.xml"); //setup video capture device , link first capture device videocapture capturedevice; capturedevice.open(0); //setup image files used in capture process mat captureframe; mat grayscaleframe; //create window present results namedwindow("outputcapture", 1); //create loop capture , find faces while (true) { //capture new image frame capturedevice >> captureframe; ...
Read more

php - render data via PDO::FETCH_FUNC vs loop -

-
i've been using 2 methods render data. the first one: function name($id,$name){ return '<div id="'.$id.'">'.$name.'</div>'; } echo implode($pdo->query("select id,name user")->fetchall(pdo::fetch_func,'name')); the second one: $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); foreach($users $user){ echo name($user->id,$user->name); } i don't understand how pdo::fetch_func works. tried figure out. however, not well-documented. could please explain fetch mode? , also, 1 performs better? thank you. both methods wrong , have learn how use templates , how separate business logic presentation logic. $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); tpl::assign('users', $users); is code business logic part. then in template <?php foreach $users $row): ?> <div id="<?=$...
Read more

The canvas has been tainted by cross-origin data in chrome only -

-
uncaught securityerror: failed execute 'getimagedata' on 'canvasrenderingcontext2d': canvas has been tainted cross-origin data i getting above error in chrome. code(following) works fine in mozilla. have not corss domain issue. why above error in chrome? var wheel_canvas, wheel_context, can_w, can_h, wheel_grd; var large_radius = 160; var small_radius = 120; var wheel_canvas = document.getelementbyid('wheel_canvas'); var wheel_context = wheel_canvas.getcontext('2d'); var can_w = $(wheel_canvas).width(); var can_h = $(wheel_canvas).height(); var centerx = can_w / 2, centery = can_h / 2; var wheel_grd = null; test('#ff0000'); function test(hex) { $('#clrpicker').css({'left': 210, 'top': 210 }); inverted = hexbw(hex); $('#color_val_show').val(hex); current_color_hex_val_selected = hex; $('#color_val_show').css({'color':inverted,'background':hex}); fillgradient...
Read more