Menu
▾
▴
gusdev-gusdev
|
From: Jeetendra S. <so...@vb...> - 2006-09-29 17:50:26
|
I had a question regarding concurrent inserts into GUS. Are the inserts into GUS synchronized ? If I have multiple plug-ins inserting data at the same time, into same tables, can this lead to inconsistent data ? There are certain cases where the newly inserted primary key is referenced by other tables. For example, if we are inserting features and their locations, the plug-in inserts feature first, and uses the primary key (na_feature_id) of the feature to insert its location(s). Are such inserts done as one atomic and synchonized transaction ? Please let me know. Thank you for your help, Jeetendra. |
|
From: <sfi...@pc...> - 2006-09-29 22:25:18
|
jeetendra- no, they are not atomic. in gus plugins whatever objects are written in one submit() function call are atomic. but in this case it seems the features are written first and the locations second. however, i do not think this will cause inconsistent data. do you have inconsistent data? steve Quoting Jeetendra Soneja <so...@vb...>: > > I had a question regarding concurrent inserts into GUS. Are the inserts > into GUS synchronized ? If I have multiple plug-ins inserting data at > the same time, into same tables, can this lead to inconsistent data ? > There are certain cases where the newly inserted primary key is > referenced by other tables. For example, if we are inserting features > and their locations, the plug-in inserts feature first, and uses the > primary key (na_feature_id) of the feature to insert its location(s). > Are such inserts done as one atomic and synchonized transaction ? > > Please let me know. > > Thank you for your help, > Jeetendra. > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Gusdev-gusdev mailing list > Gus...@li... > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > |
|
From: Jeetendra S. <so...@vb...> - 2006-09-29 23:30:45
|
Steve, Thanks for your reply. No, I haven't tried such concurrent runs of plug-ins yet. However, I might have to do so in the near future. You said that objects written in one submit() function call are atomic. So, if I add a NALocation object as a child of NAFeature object, and I call submit() on NAFeature, do these two inserts become one atomic transaction ? Thanks, Jeetendra. On Fri, September 29, 2006 6:25 pm, sfi...@pc... wrote: > jeetendra- > > no, they are not atomic. in gus plugins whatever objects are written in > one submit() function call are atomic. but in this case it seems the > features are written first and the locations second. > > however, i do not think this will cause inconsistent data. > > do you have inconsistent data? > > steve > > Quoting Jeetendra Soneja <so...@vb...>: > > >> >> I had a question regarding concurrent inserts into GUS. Are the inserts >> into GUS synchronized ? If I have multiple plug-ins inserting data at >> the same time, into same tables, can this lead to inconsistent data ? >> There are certain cases where the newly inserted primary key is >> referenced by other tables. For example, if we are inserting features and >> their locations, the plug-in inserts feature first, and uses the primary >> key (na_feature_id) of the feature to insert its location(s). Are such >> inserts done as one atomic and synchonized transaction ? >> >> Please let me know. >> >> >> Thank you for your help, >> Jeetendra. >> >> >> >> ----------------------------------------------------------------------- >> -- >> Take Surveys. Earn Cash. Influence the Future of IT >> Join SourceForge.net's Techsay panel and you'll get the chance to share >> your opinions on IT & business topics through brief surveys -- and earn >> cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVD >> EV >> _______________________________________________ >> Gusdev-gusdev mailing list >> Gus...@li... >> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev >> >> > > > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your opinions on IT & business topics through brief surveys -- and earn > cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Gusdev-gusdev mailing list > Gus...@li... > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > > -- Jeetendra Soneja Research Associate (Software Engineer) Virginia Bioinformatics Institute 0477 Washington St, Phase II - 162-04 Blacksburg, VA 24060, USA Phone: (540)-231-2789 http://www.vbi.vt.edu |
|
From: <sfi...@pc...> - 2006-09-30 08:54:05
|
jeetendra- see below. -steve Quoting Jeetendra Soneja <so...@vb...>: > > Steve, > > Thanks for your reply. > > No, I haven't tried such concurrent runs of plug-ins yet. However, I might > have to do so in the near future. > > You said that objects written in one submit() function call are atomic. > So, if I add a NALocation object as a child of NAFeature object, and I > call submit() on NAFeature, do these two inserts become one atomic > transaction ? yes. but, i don't think you need to do that. i am not clear on why you think you will have conflicts. just running two plugins concurrently should not cause a problem. > > Thanks, > Jeetendra. > > On Fri, September 29, 2006 6:25 pm, sfi...@pc... wrote: >> jeetendra- >> >> no, they are not atomic. in gus plugins whatever objects are written in >> one submit() function call are atomic. but in this case it seems the >> features are written first and the locations second. >> >> however, i do not think this will cause inconsistent data. >> >> do you have inconsistent data? >> >> steve >> >> Quoting Jeetendra Soneja <so...@vb...>: >> >> >>> >>> I had a question regarding concurrent inserts into GUS. Are the inserts >>> into GUS synchronized ? If I have multiple plug-ins inserting data at >>> the same time, into same tables, can this lead to inconsistent data ? >>> There are certain cases where the newly inserted primary key is >>> referenced by other tables. For example, if we are inserting features and >>> their locations, the plug-in inserts feature first, and uses the primary >>> key (na_feature_id) of the feature to insert its location(s). Are such >>> inserts done as one atomic and synchonized transaction ? >>> >>> Please let me know. >>> >>> >>> Thank you for your help, >>> Jeetendra. >>> >>> >>> >>> ----------------------------------------------------------------------- >>> -- >>> Take Surveys. Earn Cash. Influence the Future of IT >>> Join SourceForge.net's Techsay panel and you'll get the chance to share >>> your opinions on IT & business topics through brief surveys -- and earn >>> cash >>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVD >>> EV >>> _______________________________________________ >>> Gusdev-gusdev mailing list >>> Gus...@li... >>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev >>> >>> >> >> >> >> >> ------------------------------------------------------------------------- >> Take Surveys. Earn Cash. Influence the Future of IT >> Join SourceForge.net's Techsay panel and you'll get the chance to share >> your opinions on IT & business topics through brief surveys -- and earn >> cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >> _______________________________________________ >> Gusdev-gusdev mailing list >> Gus...@li... >> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev >> >> > > > -- > Jeetendra Soneja > Research Associate (Software Engineer) > Virginia Bioinformatics Institute > 0477 Washington St, Phase II - 162-04 > Blacksburg, VA 24060, USA > Phone: (540)-231-2789 > http://www.vbi.vt.edu > > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Gusdev-gusdev mailing list > Gus...@li... > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X