Skip to main content

Posts

Showing posts from January, 2016

Platform Independence of .NET Platform,Advantage,Disadvantages

Platform Independence of .NET Platform Its lang independent as long as that language's compiler targets the managed environment.. i.e, code written in C#.net or VB.Net or any other .Net compliant language will result in the same IL. certainly .net doesn't compile in UNIX. No compilers til date i suppose.. Heard that something similar exists to compile .net in Linux tho'.. Platform Independent does not mean O S independence in .NET terms. It means you can build a managed code and be assured it works on 32 - bit m/c, 64 bit m/c etc. Of course, at present it only supports Windows as O S, but Microsoft has left open the UNIX ( or any other O S for that matter) implementation of .NET run time. Lot of open source projects are going on in this regard. Advantages of asp with c sharp over asp with vb.net ultimately both copies in to MSIL, it depends on what application designing and what is the background of the developers who work for. C# more structured and fully OOP e

Bulkcollect and any restrictions in Bulkcollect In SQL

Question: What is bulk-collect and any restrictions in bulk-collect ? what is the use of limit clause in bulk-collect ? Answer: With bulk collect we can move all the resultant set in bulk to b processed in PL/SQL engine which kindles high efficiency but at the cost of memory ,thus the resultant set is moved in batches by giving how many records to be moved in one batch by specifying it in limit clause. Actually bulk collect performance is very high,because when ever resource table having large amount of data to fetch data using cursors that is degrade performance of the application,to improve performance of the application then we are using bulk collect,limit is an optional clause using in cursor fetch statement with bulk collect clause. Bulk collect reduces the context switching between the SQL and PL/SQL engines .. thereby increasing performance.. we can reduce the context switch to one but in case of very large data set. it's must that you use limit clause to manage t