Click here to Skip to main content
16,004,919 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralScanning image from scanner Pin
gthompson200528-Apr-04 7:00
gthompson200528-Apr-04 7:00 
GeneralRe: Scanning image from scanner Pin
vilhelmm1-May-04 0:59
vilhelmm1-May-04 0:59 
GeneralRe: Scanning image from scanner Pin
gthompson20051-May-04 10:35
gthompson20051-May-04 10:35 
GeneralNT Usergroup Pin
800XL28-Apr-04 5:38
800XL28-Apr-04 5:38 
GeneralRe: NT Usergroup Pin
Syed Abdul Khader28-Apr-04 19:00
Syed Abdul Khader28-Apr-04 19:00 
Generalhelp!! code execution taking to much time. Pin
Anonymous28-Apr-04 4:52
Anonymous28-Apr-04 4:52 
GeneralRe: help!! code execution taking to much time. Pin
Dave Kreskowiak28-Apr-04 5:09
mveDave Kreskowiak28-Apr-04 5:09 
GeneralRe: help!! code execution taking to much time. Pin
Serge Lobko-Lobanovsky10-May-04 2:09
Serge Lobko-Lobanovsky10-May-04 2:09 
Hi Santana

I think I can give you a hint in your problem.

Sometime ago I had to solve a problem where the app had to update one table from a file. The file contained approx. 400,000 records, and the app had to decide which are the new records, which need to be removed, and which to be updated.

Running it as a FOR loop would have taken ~11 hours. Running it using SQL cursors and FETCH NEXT SQL command - 7-8 hours. The following SQL stored proc it took 20 minutes:

tbl1 - table being modified
tbl2 - table which has all records from the file

[code]
UPDATE tbl1 set Inactive=1 where pID=@prid

UPDATE tbl1 SET Inactive = 0
FROM tbl2
WHERE tbl2.iID = tbl1.iID AND tbl1.pID = tbl2.pID

DELETE tbl2
FROM tbl1
WHERE tbl2.iID = tbl1.iID AND tbl1.pID = tbl2.pID

INSERT INTO tbl1 SELECT * FROM tbl2

DELETE FROM tbl2
[/code]

Hope this will help you.


Regards,
Serge (Logic Software)
GeneralJet question by a newbie Pin
Member 102309028-Apr-04 4:21
Member 102309028-Apr-04 4:21 
GeneralRe: Jet question by a newbie Pin
Dave Kreskowiak28-Apr-04 4:27
mveDave Kreskowiak28-Apr-04 4:27 
GeneralRe: Jet question by a newbie Pin
Member 102309028-Apr-04 4:33
Member 102309028-Apr-04 4:33 
GeneralTabbing Hell Pin
Greg Eales28-Apr-04 3:52
Greg Eales28-Apr-04 3:52 
Questioncan anybody give me code of getting RGB value form an image Pin
Member 41696028-Apr-04 2:34
Member 41696028-Apr-04 2:34 
AnswerRe: can anybody give me code of getting RGB value form an image Pin
Dave Kreskowiak28-Apr-04 3:59
mveDave Kreskowiak28-Apr-04 3:59 
GeneralNeed help with Loop and comparing values Pin
ingerXP27-Apr-04 22:49
ingerXP27-Apr-04 22:49 
GeneralRe: Need help with Loop and comparing values Pin
Syed Abdul Khader28-Apr-04 0:43
Syed Abdul Khader28-Apr-04 0:43 
GeneralRe: Need help with Loop and comparing values Pin
ingerXP28-Apr-04 23:52
ingerXP28-Apr-04 23:52 
GeneralRe: Need help with Loop and comparing values Pin
Ian Darling28-Apr-04 0:49
Ian Darling28-Apr-04 0:49 
GeneralRe: Need help with Loop and comparing values Pin
ingerXP28-Apr-04 23:45
ingerXP28-Apr-04 23:45 
GeneralCapturing Screenshots into an AVI file Pin
superwinsock27-Apr-04 19:03
superwinsock27-Apr-04 19:03 
GeneralRe: Capturing Screenshots into an AVI file Pin
Dave Kreskowiak28-Apr-04 1:19
mveDave Kreskowiak28-Apr-04 1:19 
GeneralRe: Capturing Screenshots into an AVI file Pin
superwinsock28-Apr-04 1:42
superwinsock28-Apr-04 1:42 
GeneralRe: Capturing Screenshots into an AVI file Pin
Dave Kreskowiak28-Apr-04 2:03
mveDave Kreskowiak28-Apr-04 2:03 
GeneralRe: Capturing Screenshots into an AVI file Pin
superwinsock28-Apr-04 2:16
superwinsock28-Apr-04 2:16 
GeneralRe: Capturing Screenshots into an AVI file Pin
Ray Cassick28-Apr-04 15:43
Ray Cassick28-Apr-04 15:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.