On Tue, May 27, 2014 at 1:58 PM, Paul Hill <[email protected]> wrote:
> It depends what the data is. A media file is fine on the HDD. > > I have an import process that reads DBFs and converts them into a SQL > database. > Our main app changed from DBF (xBase++) to C# & SQL. > It's not a 1 to 1 process and the import can take many hours. Lots of > seeking. > > The SSD excels at this kind of thing. > > ---------------------- > You may find that it is easier to use EF within a C# loader when posting the data to the SQL server than the VFP method you currently have. It is all a matter of IDs that the server will generate for you needed for child table inserts I guess. Just saying that the transaction time may be less when using EF and posting 3,5,10+ transactions to the table at once. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYLBQ6LoW1nWptWFNVF0j5WMrX+iD3kfLG9gU7Pgo2=d...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
