asp.net mvc - Moving slow database calls from MVC to background application - advice please -


i have mvc web site, users can search large recordsets sql server , oracle databases. of these recordsets can large, many thousands of records. sadly, user requirement not make searches more specific.

when user posts search request database, web page hanging before timing out (due amount of time taken query database).

we thinking removing expensive database calls mvc site, , sending query separate process run in background. when query complete, can notify user.

my proposed solution is:

1) when user completes search form in web page, display message results being generated , sent when complete 2) send sql query database can contain list of sql queries need processed 3) create windows service checks database every couple of minutes new queries 4) windows service queries database. when query completed, create csv of results, , email user

i looking advice , comments on above approach? folks think of approach process expensive database calls in background?

generally speaking requests made infrequently, mentioned, great amount of data. there chance 2 or more requests made @ same time, infrequent.

i @ optimising databases.

grateful tips.

martin :)

another option supplement existing code execute query on separate thread periodic keep-alive updates can sent requesting page while wait query results. similar way insurance quote agregator pages work. second option make results available hyperlink when ready , communicate either through website or email user. option 3 if these queries not ad-hoc type queries profile frequent combinations , pre-compute them periodically placing results new tables (sort of halfway optimising current database structure). caveat there data won't date - given time queries taking isn't important second?

whichever solution choose think it's going depend on user expectation - know want , send 1 big query , , happy? or try several queries find right combination of parameters? if latter waiting email delivery of results might not acceptable them. if want downloadable results document , know want first time may. problem see here emails going astray or taking longer user thinks should causing request resubmitted multiple times , increasing server workload - caching queries , results idea.


Comments

Post a Comment

Popular posts from this blog

inversion of control - Autofac named registration constructor injection -

does autofac support specifying registration name in components' constructors? example: ninject's namedattribute . you need use autofac.extras.attributed package on top achieve this so let's have 1 interface , 2 classes: public interface ihello { string sayhello(); } public class englishhello : ihello { public string sayhello() { return "hello"; } } public class frenchhello : ihello { public string sayhello() { return "bonjour"; } } then have consumer class, in want select instance injected: public class helloconsumer { private readonly ihello helloservice; public helloconsumer([withkey("en")] ihello helloservice) { if (helloservice == null) { throw new argumentnullexception("helloservice"); } this.helloservice = helloservice; } public string sayhello() { return this.helloservice.sayhello()...
Read more

verilog - Systemverilog dynamic casting issues -

i've code snippet following in testbench function void write_to_port( my_data_type_base data ); my_data_type_extended data_ext; if(!$cast(data_ext, data)); `uvm_error(get_type_name(), "failed cast"); `uvm_info(get_name(), $psprintf("data_ext :\n%s", data_ext.sprint()), uvm_medium) // write data_ext out port.... endfunction when run it, i'm getting uvm_error "failed cast." i'm not quire sure why $cast not returning 1. can see, i'm printing out extended class data item after casting uvm_info. can see it's being cast properly. if don't use $cast if condition, don't runtime error. isn't coding practice use if dynamic cast check if $cast returning 1 ? what might reason behind cast not returning 1 in above case? i think semicolon on line 'if' not belong? i think consumes if statement, , uvm_error executes regardless of how if evaluates: if(!$cast(data_ext, data)); <- no semico...
Read more

ios - Change Storyboard View using Seague -

i have following code checks connection server, , depending on want change views if no connection found. nsstring *connect = [nsstring stringwithcontentsofurl:[nsurl urlwithstring:@"http://myserver.com"] encoding:nsutf8stringencoding error:nil]; if (connect == null) { [self performseguewithidentifier:@"network_failure" sender:self]; } else { // other code here } my problem not change views. have added storyboard segue between 2 views identifier of network_failure . not have navigation controller or that, problem? thanks help! no not problem. first of all, in objectivec exists nil object oriented null . must use that. so: if(connect == nil) or better: if(!connect) so due fact nil not same of null , probably code does't enter in if scope . you have been able discover breakpoint. anyway: be sure set trigger segue (line) 2 view controller , , name network_failure (that not best name. should instead view1toview2 ) as, m...
Read more