i have to insert till 30000 record from delphi into MsAccess database using DAO. with normal insert into this take a lot of time > 10 minutes... I've read there is a procedure to insert directly from txt file (using adoCommand) but i don't understand how to made it.  Someone can help me?  Thank you for your help
I need to insert 800000 records into an MS Access table. I am using Delphi 2007 and the TAdoXxxx components. The table contains some integer fields, one float field and one text field with only one character. There is a primary key on one of the integer fields (which is not autoinc) and two indexes on another integer and the float field.  Inserting the data using AdoTable.AppendRecord(...) takes > 10 Minutes which is not acceptable since this is done every time the user starts using a new database with the program. I cannot prefill the table because the data comes from another database (which is not accessible through ADO).  I managed to get down to around 1 minute by writing the records to a tab separated text file and using a tAdoCommand object to execute  insert into table (...) select * from [filename.txt] in "c:\somedir" "Text;HDR=Yes"   But I don't like the overhead of this.  There must be a better way, I think.  EDIT:  Some additional information:   MS Access was chosen because it does not need any additional installation on the target machine(s) and the whole database is contained in one file which can be easily copied. This is a single user application. The data will be inserted only once and will not change for the lifetime of the database. Though, the table contains one additional field that is used as a flag to indicate that the corresponding record in another database has been processed by the user. One minute is acceptable (up to 3 minutes would be too) and my solution works, but it seems too complicated to me, so I thought there should be an easier way to do this. Once the data has been inserted, the performance of the table is quite good. When I started planning/implementing the feature of the program working with the Access database the table was not required. It only became necessary later on, when another feature was requested by the customer. (Isn't that always the case?)   EDIT:  From all the answers I got so far, it seems that I already got the fastest method for inserting that much data into an Access table. Thanks to everybody, I appreciate your help.
How widely-accepted is "What do you got?" to Americans? Watching , I noticed that Melanie Griffith twice asked    I recognise this as an American construction which sounds strange to me — Brits invariably say either "What have you got?" or "What do you have?". But I'd be interested to know if it's considered "normal" by most/all Americans, or if it's regionally or otherwise restricted. Dates and times: "on", "in", "at"? I’m often confused when I speak about times and dates. What is the rule for using on, in, and at in the following sentences?   I will do it ___ Tuesday. We married ___ March. He returned ___ the same day. Every day ___ the same time, I walk the dog. My Arcpy code is not working in ArcMap 10.1 because an error with the last line:      Error 000824: The tool is not licensed.    I have all my extensions turned on, so I don't know why I would be getting this error. It seems I only need to import arcpy.sa.   Did I do this correctly, or are there other modules that should be imported for this code to work?  import arcpy, os, string, glob, sys from arcpy import env from arcpy.sa import *  env.workspace = r"C:\VMshared\small_example_valley8\SD2part" outFolder = r"C:/VMshared/small_example_valley8/SDpartINT/INT"  for rasterFile in arcpy.ListRasters("*.tif"):     oName, oExt = os.path.splitext(rasterFile + ".tif")     outRaster = os.path.join(outFolder, oName + ".tif")      arcpy.gp.Int_sa(rasterFile,outRaster) I am recording videos on iPhone and uploading them to my Linux server. Users can see these videos on website. If users are seeing videos on mac or iDevices the video is looking fine but when users are seeing that video on windows systems these videos are getting rotated.   I am assuming this is because of some apple's flag in the recorded video which Windows systems are not able to read. Can I record videos in some way so they don't get rotated on Windows systems? Or is there any way I can re-encode videos with proper interface orientation using FFmpeg?  I am open to both FFmpeg or iOS way. How can I get fireworks? What are the requirements for making fireworks appear at the end of a level in the original Super Mario Bros.? When should I have an NPC actively investigate an illusion created by the Phantasmal Force spell? The phantasmal force spell can be broken if the victim examines the illusion and makes a successful investigation check against the spell's DC.  What general guidelines should I use to decide when the victim of phantasmal force should use its action to examine the illusion?  Suppose the caster makes an orc think it is being attacked by a wolf.  Should the orc always examine the wolf until the spell ends? Or should the orc use its action to attack the wolf, defend itself, or run away? I have opened a new blender file and deleted the default cube, then imported an obj file . I did not see any thing so i selected it and i zoomed ,nothing appears.In the outliner i saw the object name ,But in the info panel i see that there isn't any verts/faces/edges.  When i opened the obj file in a text editor i found Mesh data in it. I tired this in all blender versions (2.78c/2.78.5/7.9). Can any one help how to view the mesh? I always wondered if children who graduate from Hogwarts have an education that is actually worth while in the real world.  Do the children learn math and English?  I can see History of Magic as practical. I know of Arithmancy, but that's the study of the magical properties of numbers, not math.   Since Hogsmead is one of the very last all-magical towns, it's a fair assumption that a majority of the students at Hogwarts will be living in non-magical towns or cities. If practical classes (like math or English) aren't taught, then how do these students function in the non-magical cities? Calculating the limit $\lim((n!)^{1/n})$ Find $\lim_{n\to\infty} ((n!)^{1/n})$. The question seemed rather simple at first, and then I realized I was not sure how to properly deal with this at all. My attempt: take the logarithm,  $$\lim_{n\to\infty} \ln((n!)^{1/n}) =  \lim_{n\to\infty} (1/n)\ln(n!) =  \lim_{n\to\infty} (\ln(n!)/n)$$ Applying L'hopital's rule:  $$\lim_{n\to\infty} [n! (-\gamma + \sum(1/k))]/n! = \lim_{n\to\infty} (-\gamma + \sum(1/k))=  \lim_{n\to\infty} (-(\lim(\sum(1/k) - \ln(n)) + \sum(1/k))  = \lim_{n\to\infty} (\ln(n) + \sum(1/k)-\sum(1/k)  = \lim_{n\to\infty} (\ln(n))$$ I proceeded to expand the $\ln(n)$ out into Maclaurin form $$\lim_{n\to\infty} (n + (n^2/2)+...) = \infty$$ Since I $\ln$'ed in the beginning, I proceeded to e the infinity  $$= e^\infty  = \infty$$  So am I write in how I approached this or am I just not on the right track? I know it diverges, I was just wanted to try my best to explicitly show it. How to completely remove Garage Band from macOS? Phone keeps rebooting on Volume Up + Power (trying to install ROM) I tried to install Android's ROM and got ERROR 7, then I wiped out cache, data, internal storage, where was twrp.apk installed. After that I cant get into boot menu (with Install, Wipe... buttons). Then I copied twrp to the phone: sudo fastboot flash recovery &lt;twrp.img&gt; Tried versions 3.2.1-0 and 3.4.0-0, because I heard for certain phone (I have Xiaomi Mi4) it's necessary to use proper version, though I don't know which. What's going on now: I can successfully can get to the nice splash screen using Volume Down + Power, then on my PC I give sudo fastboot reboot command and press Volume Up + Power and here is the problem: It has no effect, it just keeps rebooting (I see only Xiaomi's logo). Received an email intended for another person I'm not really sure how email routing works, but someone ordered something on Amazon and I received the email instead of them.  Or maybe we both got it, I don't know.  The order doesn't show up in my account, so I'm certain I wasn't charged for it, but I shouldn't be getting other peoples' emails.  We'll say that my email is johndoe1@gmail.com, and somebody who's email is john.doe1@gmail.com places an order on Amazon.  The confirmation email is sent to me at johndoe1@gmail.com.  I checked the email header, and it did say To: john.doe1@gmail.com which is not my email address.  At first I thought that Google ignores periods in email addresses, but I tested the account setup and it doesn't give any error when you put a period in the address.  I didn't create the account; I just used the "check availability" function and the address I chose with a period was fine.  Maybe someone with knowledge about how Email works could tell me why this happened.  Is this a bug in the way Amazon sends emails?  Or is it a bug in how Google receives them?  Who should I report this issue to? Smoke Generator does not work When I try to run the smoke simulator in Blender 2.62 I get no smoke at all. When I attempt to render, the only output is a black screen. What am I doing wrong here that is making the smoke simulation not render?  Is it a mistake I made, or a problem with Blender version 2.62? pass 1 environment variable using sudo How do I do this? I created a user without a home directory and now I want to create one. Not just a folder called new_user, I want the default home directory with all it's folders and hidden files, etc. I sadly haven't been able to answer this questions using Google. In beamer, I'd like to make the default font for the entire title page, as well as frame titles, to be the default font from the old  (example ). What does "more buyers than sellers" in technical analysis of stocks actually mean? I often hear/read technical analysts looking at volume and price action on a chart and claiming that there are "more buyers than sellers" or vice versa.  Since every trade requires a buyer and a seller, how can volume/price signify more of one than the other?  What does that actually mean?  When I hear that there are "more buyers," I get the impression they actually mean more "professional" or "institutional" buyers, but I could just be imagining that meaning.  But wouldn't this "more buyers" situation actually represent a smaller number of large buyers placing multiple orders? (and those orders would be matched by a larger number of smaller investors on the other side of the trade?)  Maybe I have my assumptions backwards and "more buyers" is what they say when they actually mean "more retail buyers and less institutional buyers"?  Or maybe the expression has nothing to do with number of buyers/sellers at all and is just some arbitrary technical analysis situation?  What situation is it that they're trying to describe?  If the "smart money" traders had placed larger orders, then there would have to be equally large sellers on the other side of that large trade, right?  I know trades often get broken up, but if the trades had been broken up it would be equivalent to "large traders placing multiple orders" scenario described above.  If the trades were not broken up, then there would not be an imbalance in the "number" of "smart" vs. retail buyers/sellers, right?  UPDATE/EDIT: I usually see this stated in reference to technical indicators such as RSI.  I don't typically hear people saying "there are more buyers than sellers" in the situations you guys are describing with more unfilled orders on one side of the (potential) trade (though that would make more sense if that was what they were talking about).  See for example: Check Constraint with Case Statement I read many places that the rule of thumb for swap space is to double the amount of physical RAM. However, 32 GB does seem a LOT. Do I need that much? Do I need it at all with this high amount of physical RAM? How to show an alert when user navigates to another page without filling the form? I have a form created by a custom module. Now I want to show an alert like ("Please fil the complete form before navigating otherwise lost all the data") if the user navigate to another page without filling all required fields.  How can I do so?