AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Bulk loading1/24/2024 Use BULK INSERT w/ TABLOCK hint - cuts the load to 10 minutes.Īll the above are with a batch size of 5000 I tried the following things to speed things up:Īdd TABLOCK hint to bcp - cuts the load to 15 minutes It uses BCP.Īs written, it takes about 23 minutes to load the data, and about 45 minutes to create 2 indexes on the 334 million rows. The process is built on the "import first, index later" methodology. The data file is sorted on the first column Bulk cargo transports therefore require a high level of expertise and extensive experience for the optimal execution of the transport.We've got a process that's importing a 7gig / 334 million row data file. The carrier decides which means of transport is suitable for the particular bulk cargo. In sea freight, bulk goods are transported in bulk holds or bunkers on the ship. Vehicles with push floors are also used or the bulk goods are transported as bagged goods or in big bags. Weather-sensitive goods such as salt or sugar require a silo vehicle for transport. Construction debris, gravel or sand can be transported in open dump trucks or high-sided trucks. The type of bulk material determines the means of transport. However, materials with the described properties can be discharged without any problems with a tilting beam bottom. In the case of difficult (complex) bulk solids, for example, cohesive, hygroscopic, segregating, abrasive, non-flowing or even pasty bulk solids, the discharge (especially the precisely metered discharge) is more than demanding. In combination with the suitable geometry of the silo and a continuous activation of the (rotating) tilting beams, even very poorly flowing bulk solids can be discharged in this way. These are usually placed under silos or containers. In this case, a tilt-beam bottom is used for discharge during storage and transport. In the case of cohesive, moisture-binding, segregating, abrasive or strongly cohesive bulk solids, the discharge and, above all, the exact metering is quite complex. Metering systems operate either volumetrically, dispensing the bulk material by volume, or gravimetrically, weighing the bulk material and dispensing it by mass. Dosing can also be discontinuous (individual batches) or continuous (constant flow). With the so-called coarse flow, high metering capacities are achieved, whereas in the fine flow, metering is very precise. These include, above all, dosing screws, which are often used in conjunction with vibration support. Here, too, appropriate equipment is used. Likewise, accurate batching of certain bulk solids is very demanding. The application of the appropriate bulk solids technology and conscientious planning of flowability represent critical variables in the handling of bulk solids. Often, a bulk material unpredictably shows a different behavior, although otherwise all parameters of storage and bulk material mechanics have remained the same. When discharging the bulk material, it is not only the previously suitable storage location or container that is decisive, but also the availability of the appropriate plant technology in order to avoid problems such as spillage. This includes the determination of bulk density, particle size, particle shape, moisture and other relevant parameters. Therefore, the specification of the bulk material in question is an important point. In practice, the storage and especially the discharge of bulk materials are sometimes complex due to the unpredictability of the bulk material. Storage and discharge of bulk materialsīulk cargo are stored in silos, bunkers or, in the case of insensitive goods, in the open air. Various pellets, granules, chips, feedstuffs and other powdery goods are also referred to as bulk goods. Likewise, foodstuffs such as grain, salt, sugar, flour or coffee count as bulk material. A bulk refers to such goods that can move freely in the storage or transport container or are not further secured.īulk cargo include building materials such as gypsum, sand, gravel and cement, and also raw materials such as road salt, ore or slag. The handling of bulk materials is a DIN standard defined process, the “pouring”. Important quantities of bulk material are: There are free-flowing (cohesionless) bulk solids and cohesive (cohesive) bulk solids. Bulk solids are primarily differentiated according to how flowable they are. Bulk material is present in lumpy, granular or powdery form. Home Technical term Bulk cargo Bulk cargoīulk solids are goods that are present in a pourable form.
0 Comments
Read More
Leave a Reply. |