Hello: > > I then use an OleDbDataReader that has the data from the old Access > Database. I go through a “while (reader.Read())” loop to get the data, > and at the end of each iteration use a “newCommand.ExecuteNonQuery();” > to execute the statement. When I have got all of the data from that > table, I do a “transaction.Commit();” and then move onto the next table. > Can you send a test case showing that loop, please ?? > > I do have a Firewall and Antivirus running, but it is the same > firewall that is running when I do the same inserts with Access. Any > time delays from accessing the file system should then be the same > whether I am using Access or Firebird. > I don't know how Access works but i doubt the Firewall will affect it ( while the provider uses tcp/ip to connect to the firebird server and *will be* affected by the firewall ). > > Carlos, I do not know what you meant by using a prepared command, or > creating a new one. By prepared command, do you mean do I have a all > of the “INSERT INTO …” commands in a text file somewhere? If that is > the case, then no I do not have that. I guess we could go that route > if necessary though. > Using a single FbCommand Instance for all the inserts ( and calling Prepare before doing any insert )
-- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido reyes en su familia. ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
