|
-
Urgent:Optimum solution for reading Tab delimited file data into a database.
Hai,
Query: I need to import tracking log file(name of the file is like
yyyymmdd) data of MS Exchange server into database using Visual basic.The
file data is in tab delimited format.Can you suggest me a right logic for
impoting into database.
I have used file system object,ADO 2.5 Stream object to read Tracking
log file.My file size is more than 8MB,when i read using File system object
or Stream object it is taking 20 - 30 minutes(tooooo much).
Why is it taking so much time can you suggest me some other optimum
solution for reading it into database.
My entire project is based on your suggested technology.
Looking forward for your valuable suggestion...........
With regards,
Niranjan(niranjan@cspl.com)
Software engineer
Congruent solutions private limited
#2;Ramavaram road,
Chennai-6000 089
Tamil nadu
India
Phno:91-44-2343941
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Bookmarks