Hullo Luc I need a database as I need to perform some operations that only a database can do effectively. no its not a multiple user program. I have a large quantity of data that I want to write to the database as fast as possible. I thought of dividing the data into ,say, 5 parts and use 5 threads to put these 5 parts so that my work is completed in 1/5th time. Am I correct in thinking so? If I do that would that result in data loss?

thanks for answering the reason that I don't want to use sqlite are: 1. multi-thread writing is not supported. 2. it requires a sqlite.dll file in the exe folder to work. If you think that performance wouldn't differ much using multiple threads then i can very well use a single thread. I'll carry out the tests. If you know a method so that my app can become a two file app ie one exe and one database file then please tell me. in the above post ANDY_L_J has pointed out that .sdf databases need 7 dlls. if that's that then using sqlite is a better option as it requires only 1 dll file.

Hi all I am using VB 2008. I am developing a program that writes millions of lines to a database. The type of database isn't decided yet. I think I'll be using SQL databases (sdf) that VB provides. I need to add millions of rows at one time. Can I do that by using multiple threads? I mean I'll divide the data in ,say, 6 parts and write each part using a different thread. My whole purpose is to save time. As fast as the writing occurs my boss is that happier. He doesn't want to know how that is being done, he just wants to know that its been done. I know sqlite can't do this. Is there any other database which is able to do that. It must not use any dll. My boss wants the app to be independent. Would that result in data loss? even if the rows are written out of order, no problem. -- Modified Sunday, May 16, 2010 7:27 AM

I performed some search and found that you need "sqlite.dll" in the same folder as the exe file. I know its only 441 KB in size but its my boss. He's mad. can you give me any other choices?

hey thanks buddy! will that be portable? the exe file should run without the need of any dlls.

He knows me by another name. anyway I don't think he visits the coding forums! ;)

thanks for the reply. My boss says that it should has the extension of .db Thats the only matter with him. He's a jerk. I will now give an overview of my (strictly my boss') the database extension should be .db (I dunno why he's sticking with that) only one table is required. the application should run on any windows with .net 3.5 (he calls that portable) the read/write speed should be fast. that's all.

Hi all I need to work on databases that have .db extension. My boss insists that this type of database is the fastest. i tried searching for it and found that its a thumbnail database on filext.com I need to put text on the database and am sure its possible. and on googling I found several links for java,etc. I don't know nothing about .db files but I know how to handle ADO.NET Help me with some info about them like its source website,etc (any info is welcome) Thanks