How to improve the performance of c# program -


i trying to extract sdf file geodatabase.as new sdf file created ,the memory usage program increases.to overcome issue have tried reaseing connection sdf file , tried release resources using gc.collect() method still problem persist. 

/// <summary> /// feature data geodatabase file /// </summary> /// <param name="dictionaryproperty"> schema of table </param> /// <param name="table">table connection of gdb file</param> /// <param name="sdffilepath">sdf file path</param> static void getfeaturedata(dictionary<string, property> dictionaryproperty, table table, string sdffilepath) {     int filecount = 1; ;     list<property> propertylist = new list<property>();     ienumerable<string> propertycoll = dictionaryproperty.select(i => i.value).where(i => i.datatype == "oid").tolist().select(i => i.propertyname);     string propertyname = null;     foreach (string item in propertycoll)     {         propertyname = item;     }     (int rowno = 1; rowno <= table.rowcount; rowno++)     {         foreach (row row in table.search("*", propertyname + "=" + rowno.tostring(), rowinstance.recycle))         {             foreach (property property in dictionaryproperty.values)             {                 property objproperty = new property();                 objproperty.propertyname = property.propertyname;                 objproperty.datatype = property.datatype;                 switch (property.datatype)                 {                     case "smallinteger":                         if (row.isnull(property.propertyname))                         {                             objproperty.propertydata = "";                         }                         else                         {                             objproperty.propertydata = row.getshort(property.propertyname).tostring();                         }                         break;                      case "geometry":                         switch (row.getgeometry().geometrytype.tostring())                         {                             case "point":                                 pointshapebuffer pointgeometry = row.getgeometry();                                 objproperty.geometrytype = property.geometrytype;                                 objproperty.geometrydata = pointgeometry.point.x + " " + pointgeometry.point.y;                                 break;                                  objproperty.geometrydata = coord;                                 objproperty.propertydata = coord;                                 objproperty.geometrytype =   property.geometrytype;                                 coord = string.empty;                                 break;                             case "polygon":                                  break;                         }                         break;                     case "globalid":                          break;                 }                 propertylist.add(objproperty);             }             insertfeaturedata(table, propertylist, sdffilepath);             propertylist.clear();         }     }     console.writeline(filecount + "file completed");     filecount++; } /// <summary> /// insert feature data sdf file path /// </summary> /// <param name="table"></param> /// <param name="propertylist">schema defination</param> /// <param name="sdffilepath"></param> static void insertfeaturedata(table table, list<property> propertylist, string sdffilepath) {     iconnection con = openfdosdfconnection(sdffilepath);     iinsert insertcommand = (iinsert)con.createcommand(osgeo.fdo.commands.commandtype.commandtype_insert);     insertcommand.setfeatureclassname(gettablename(table));     foreach (property objproperty in propertylist)     {         switch (objproperty.datatype)         {             case "oid":                 if (!string.isnullorempty(objproperty.propertydata))                 {                     insertcommand.propertyvalues.add(new propertyvalue(objproperty.propertyname, new int64value(convert.toint64(objproperty.propertydata))));                 }                 else                 {                     insertcommand.propertyvalues.add(new propertyvalue(objproperty.propertyname, null));                 }                 break;              case "geometry":                 switch (objproperty.geometrytype)                 {                     case "point":                         if (!(objproperty.geometrydata == ""))                         {                             fgfgeometryfactory factory = new fgfgeometryfactory();                             directpositioncollection pcollection = new directpositioncollection();                             string[] points = objproperty.geometrydata.split();                             insertcommand.propertyvalues.add(new propertyvalue("geometry", new geometryvalue(factory.getfgf(factory.createpoint(factory.createpositionxy(convert.todouble(points[0]), convert.todouble(points[1])))))));                         }            }     }     insertcommand.execute();     insertcommand.dispose();     con.close(); }


-

Comments

Post a Comment

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

there several posts converting mat bitmap using utils.mattobitmap() function. i'm assuming function can called in java layer after importing utils class. i want transfer data memory address pointed uint32_t* bmpcontent; in code below. jniexport void jnicall java_com_nod_nodcv_nodcvactivity_runfilter( jnienv *env, jclass clazz, jobject outbmp, jbytearray indata, jint width, jint height, jint choice, jint filter) { int outsz = width*height; int insz = outsz + outsz/2; androidbitmapinfo bmpinfo; if (androidbitmap_getinfo(env, outbmp, &bmpinfo) < 0) { throwjavaexception(env,"gaussianblur","error retrieving bitmap meta data"); return; } if (bmpinfo.format != android_bitmap_format_rgba_8888) { throwjavaexception(env,"gaussianblur","expecting rgba_8888 format"); return; } uint32_t* bmpcontent; if (androidbitmap_lockpixels(env, outbmp,(void**)&bmpcontent)...
Read more

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

i trying hit soap api in application login purpose , getting above mentioned error , can 1 tell me going wrong , first time soap apis. here code hit soap :- vector<object> args = new vector<object>(); hashtable<string, object> hashtable = new hashtable<string, object>(); hashtable.put("email", "mss.siddhart28@gmail.com"); hashtable.put("password", "siddharth"); args.add(hashtable); soapserializationenvelope envelope = new soapserializationenvelope( soapenvelope.ver11); envelope.dotnet = true; envelope.xsd = soapserializationenvelope.xsd; envelope.enc = soapserializationenvelope.enc; (new marshalhashtable()).register(envelope); httptransportse androidhttptransport = new httptransportse( "http://tempuri.org/", 15000); androidhttptransport.debug = true; string result = ""; try { soapobject request = new soapobject("http:...
Read more

python - How to remove the Xframe Options header in django? -

i have made page has iframe . inside iframe want show multiple different links article facebook, or news, or youtube video or other possible url. but, due xframe header, unable so. referred following link: https://docs.djangoproject.com/en/1.8/ref/clickjacking/ , django xframeoptionsmiddleware (x-frame-options) - allow iframe client ip but didn't help. my settings.py file's middleware_classes is: middleware_classes = ( 'django.contrib.sessions.middleware.sessionmiddleware', 'django.middleware.common.commonmiddleware', 'django.middleware.csrf.csrfviewmiddleware', 'django.contrib.auth.middleware.authenticationmiddleware', 'django.contrib.auth.middleware.sessionauthenticationmiddleware', 'django.contrib.messages.middleware.messagemiddleware', 'django.middleware.clickjacking.xframeoptionsmiddleware', ) from http://django-secure.readthedocs.org/en/latest/middleware.html , found using ...
Read more