Speeding it up?
Any advice you can offer would be greatly appreciated or if you have any good links where I could go to get some tips, etc. - and just so you know, I am NOT a database admin by any means.
Also, it is not a simple, read a line from a file, process it, and put it in a database...
Finally found it
While using a process explorer to compare dlls running on each machine, we noticed the slow machines were running an odbctrac.dll (trace file).
Our application has a sql configuration file (sql.ini) where we put such information as DSN settings. The sql.ini files on the slow...
The app is written with Unify's Team Developer (this company has changed its name several times over the years: Centura, SQL Windows, Gupta, etc.). This company also has its own database engine: SQLBase. We are currently doing a rewrite of the code and changing the back-end to SQL Server - this...
We are developing an application which uses SQL Server 2008 R2 Express Edition. The application reads an index file, processes the lines, and inserts data into the database. On two machines, a particular import process takes 3 minutes - on two other machines, the same process takes 13 minutes...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.