python - MongoEngine Query Optimization -


i have 2 collections scenariodrivers , modeldrivers has 1 many relationship each other.

class scenariodrivers(document):     meta = {         'collection': 'scenariodrivers'     }     scenarioid = referencefield('modelscenarios')     driverid = referencefield('modeldrivers')     drivercalibrationmethod = stringfield()     segmentname = stringfield()     drivervalue = listfield()     calibrationstatus = stringfield()     adjustedvalues = listfield(default=[])     createdate = datetimefield(default=objectid().generation_time)     lastupdatedate = datetimefield(default=datetime.utcnow())  class modeldrivers(document):     meta = {         'collection': 'modeldrivers'     }     portfoliomodelid = referencefield('portfoliomodels')     drivername = stringfield()     createdate = datetimefield(default=objectid().generation_time)     lastupdatedate = datetimefield(default=datetime.utcnow())     fieldformat = stringfield()     driverdata = listfield()

my query this.

class getcalibrateddrivers(resource):     def get(self, scenario_id):         scenario_drivers_list = []          scenario_drivers = scenariodrivers.objects(scenarioid=scenario_id).exclude('scenarioid').select_related(1)         scenario_driver in scenario_drivers:             scenario_driver_dict = {                 'id': str(scenario_driver.id),                 'driverid': str(scenario_driver.driverid.id),                 'segmentname': scenario_driver.segmentname,                 'calibrationmethod': scenario_driver.drivercalibrationmethod,                 'calibratedvalues': exchange(scenario_driver.drivervalue),                 'adjustedvalues': scenario_driver.adjustedvalues,                 'lastupdatedate': formatted_date(scenario_driver.lastupdatedate),                 'fieldformat': scenario_driver.driverid.fieldformat             }             scenario_drivers_list.append(scenario_driver_dict)          return {             'drivercalibrations': scenario_drivers_list         }

the query matches 1140 records , construct dictionary , make list.

but api call takes 30s process 1140 records. missing? please help. using latest version of pymongo , mongoengine.

i think problem not query, looping on 1140 records. not see use of referenced objects should consider removing select_related(1). once that, if want convert reference object ids string, can use as_pymongo() default you. , if must read data in specific format formatted_date or exchange, better save them part of document. i.e. save formattedlastupdatedate lastupdatedate. in mongodb, have think read specific logic when save document.


-

Comments

Post a Comment

Popular posts from this blog

renaming files in a directory using python or R -

i went across similar questions of renaming files in directory using python. i have these files in directory want rename: -statistical_analysis_with_r -statistical_pattern_recognition_3rd_edition -statistical analysis r -statistical pattern recognition 3rd edition for wrote script in windows: def naming(so): import re w=re.split('[ _]+',so) r=[] in w: r.append(i.capitalize()) print(' '.join(r)) import os c in os.listdir(os.getcwd()): if c.endswith(".pdf"): os.rename(c,naming(c)) print(os.listdir(os.getcwd())) but getting error: statistical analysis r.pdf traceback (most recent call last): file "<ipython-input-79-d7f645d6d3e5>", line 4, in <module> os.rename(c,naming(c)) typeerror: rename: can't specify none path argument can what's going on? and doing same thing using r (www.r-project.org)? loads of in advance. your naming functio...
Read more

c# - ajax - How to receive data both html and json from server? -

i have referenced this topic , doesn't solve problem. i'm using mvc 5 c#. have used code receive data server data type json . $.ajax({ url: "/mycontroller/myaction", type: "post", datatype: "json", success: function (data) { if (data.result) { alert('successfull'); } else { alert(data.ex); } } }); and controller code: [httppost] public actionresult myaction() { try { return json(new { result = "true", ex = "" }); } catch (exception e) { return json(new { result = "false", ex = e.message }); } } i use way data type html: $.ajax({ url: "/mycontroller/myaction", type: "post", datatype: "html", success: function (data) { $(".mydiv").append(data); } }); and controller should be: [httppost] public actionresult myaction() { return partialview("_...
Read more