Re: Processing speed
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Peter W Johnson wrote:
> Hi guys,
>
> I have the following code which I feel runs slow. I have tried to
> include de-referencing variables and releasing unmanaged resources.
> Am I doing the right thing or is there a better way of going about
> this.
> Briefly, the code opens a table containing imported data. The code
> deletes all the old data from two tables. When empty these two tables
> are opened to gather the data from the import. A lookup is carried
> out on one piece of data, the result being entered in the data table.
>
> Any ideas on the best way to approach this?
How about using a stored procedure in the database to empty the tables? Or
drop the tables and re-create them?
Actually, it looks like the entire thing could be done with stored
procedures. Then there would be no back-and-forth data transfer between your
app and the database.
Andrew
.
Relevant Pages
- Re: 3vl 2vl and NULL
... >>interpretation in the languages of the database. ... > Uncle Vernon be included or not? ... We don't know Uncle Vernon's age and we can only work with the ... >>> in the database is empty. ...
(comp.databases.theory) - Re: Extended Stored Procedure: Get the current db of the client
... with the caveat that you don't recommend it because Microsoft ... of a stored procedure versus umpteen of the same stored procedure spread ... I am not going after Gert Sue. ... the database context as a parameter if you need it, ...
(microsoft.public.sqlserver.odbc) - Re: 3vl 2vl and NULL
... >> properties that are represented by the values in my database. ... >>> If I look at my empty mug I can truthfully say ... >> that stores the amount of liquid in your mug. ... >thinking of the cell has holding an empty set would make sense, ...
(comp.databases.theory) - Trying to set up a SQL Server Agent Account and I hit a wall....
... Our database is on SQL Server 2005, however it is set to compatibility mode ... You may need to set the compatibility level ... of the current database to a higher value to enable this feature. ... for the stored procedure sp_dbcmptlevel. ...
(microsoft.public.sqlserver.security) - Re: Extended Stored Procedure: Get the current db of the client
... I am not going after Gert Sue. ... the database context as a parameter if you need it, ... Did you ever write an extended stored procedure? ... different than an extended stored procedure, so that is not giving you want ...
(microsoft.public.sqlserver.odbc) |
|
