

I wish the requestors or the person who is raising question to pick what they need for and understand easily. There can be numerious solution for a problem. You pull out the data and puts them in an undefined element type?!? Development manager probably scream and hold his head! it is well knows that vb.net developers do not like to use the element type and just use "Dim X" but you should use "Dim x as Dataset". but In conclusion: It's bad code as a Dot Net Development and worse as DBA, if you allow me to say gently. Of determining Type "RS" takes system resources

If you do not, Visual Basic uses default settings."ĭo you want to use the default settings? what are the default settings for the that specific data? the data can be insert to several types of objects like dataset (probably this is the default), datatable and more. You pull out the data and puts them in an undefined element type?!? Development manager probably scream and hold his head! it is well knows that vb.net developers do not like to use the element type and just use "Dim X" but you should use "DimīOL: "You can specify each variable's data type in the Dim statement. It's absolutely "database spam".The DBA sees something like that needs to shout from the roof Looping in external application and each time sending a separate query to the database for each record. You pass on the data in loop one row after the other and put them one by one into the table?!?

You take the data out to external application from the database just to put it back in?!? If there was a competition to find the worst way it was winner :-)įirst. This partition space is purely for testing purposes.RSingh, This is one of the worst ways I could think of. Since it is temporary partition, you shouldn't save any important data in it. Once you reboot the system, the partition including its contents will be gone! Save some files and/or directories in it and reboot the system to see if they are still available. Now you can use this partition space for any purpose. Sample output: Filesystem Size Used Avail Use% Mounted onĪs you can see, the size of the temporary partition is 100M. Let us examine the /mnt directory space using "df" command: # df -h /mnt/ Tmpfs on /mnt type tmpfs (rw,relatime,seclabel,size=102400k) You can verify if this temporary partition is mounted or not using "mount" command: # mount The above command will create a temporary partition with size 100 MB in tmpfs and mount it under /mnt directory. To mount a temporary partition in memory in Linux, simply run the following command as root or sudo user: # mount -t tmpfs tmpfs /mnt -o size=100m Mount A Temporary Partition In RAM In Linux
