Click here to Skip to main content
16,007,472 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Unable to Upgrade Vb6 to Vb.net Pin
Henry Minute13-Jan-09 9:25
Henry Minute13-Jan-09 9:25 
GeneralRe: Unable to Upgrade Vb6 to Vb.net Pin
sarfarazaliqureshi13-Jan-09 9:32
sarfarazaliqureshi13-Jan-09 9:32 
QuestionSQL Query Syntax Issue Pin
tcd6713-Jan-09 5:59
tcd6713-Jan-09 5:59 
AnswerRe: SQL Query Syntax Issue Pin
Wendelius13-Jan-09 6:28
mentorWendelius13-Jan-09 6:28 
GeneralRe: SQL Query Syntax Issue Pin
tcd6713-Jan-09 6:46
tcd6713-Jan-09 6:46 
GeneralRe: SQL Query Syntax Issue Pin
Wendelius13-Jan-09 7:24
mentorWendelius13-Jan-09 7:24 
Questionwindows service structure/custom actions Pin
captainmogo13-Jan-09 4:42
captainmogo13-Jan-09 4:42 
AnswerRe: windows service structure/custom actions Pin
Wendelius13-Jan-09 6:40
mentorWendelius13-Jan-09 6:40 
I would guess that your timing system is efficient enough considering the task you'r doing. Creating and deleting partitions isn't a small job for the database engine.

Just a question: You didn't say what database you're using, but if it is SQL Server, why wouldn't you create a job under SQL Agent. You could do the programming using T-SQL thus eliminatig roundtrips to database. Also the database wouldn't depend on any service outside the SQL Server itself. For example if your service is stopped, halted etc, your database wouldn't act as expected. Also I believe that both the performance and maintainability would increase.

The need to optimize rises from a bad design.My articles[^]

GeneralRe: windows service structure/custom actions Pin
captainmogo13-Jan-09 8:12
captainmogo13-Jan-09 8:12 
GeneralRe: windows service structure/custom actions Pin
Wendelius13-Jan-09 8:57
mentorWendelius13-Jan-09 8:57 
QuestionVBA - Changing a name of a Worksheet Pin
Dalek Dave13-Jan-09 4:16
professionalDalek Dave13-Jan-09 4:16 
AnswerRe: VBA - Changing a name of a Worksheet Pin
Dalek Dave13-Jan-09 4:20
professionalDalek Dave13-Jan-09 4:20 
QuestionMaximise already created process Pin
hrishiS12-Jan-09 23:56
hrishiS12-Jan-09 23:56 
AnswerRe: Maximise already created process Pin
EliottA13-Jan-09 2:48
EliottA13-Jan-09 2:48 
AnswerRe: Maximise already created process Pin
Henry Minute13-Jan-09 6:13
Henry Minute13-Jan-09 6:13 
AnswerRe: Maximise already created process Pin
Dave Kreskowiak13-Jan-09 8:24
mveDave Kreskowiak13-Jan-09 8:24 
GeneralRe: Maximise already created process Pin
hrishiS14-Jan-09 17:23
hrishiS14-Jan-09 17:23 
GeneralRe: Maximise already created process Pin
hrishiS3-Feb-09 23:45
hrishiS3-Feb-09 23:45 
GeneralRe: Maximise already created process Pin
Dave Kreskowiak4-Feb-09 2:21
mveDave Kreskowiak4-Feb-09 2:21 
QuestionBack up ms access database using vb.net2005 Pin
hrishiS12-Jan-09 23:36
hrishiS12-Jan-09 23:36 
AnswerRe: Back up ms access database using vb.net2005 Pin
Tom Deketelaere13-Jan-09 1:42
professionalTom Deketelaere13-Jan-09 1:42 
AnswerRe: Back up ms access database using vb.net2005 Pin
Wendelius13-Jan-09 6:52
mentorWendelius13-Jan-09 6:52 
QuestionImage Processing Pin
nishkarsh_k12-Jan-09 19:24
nishkarsh_k12-Jan-09 19:24 
AnswerRe: Image Processing Pin
Guffa13-Jan-09 1:03
Guffa13-Jan-09 1:03 
QuestionActive Directory Computer Groups in VBA Pin
AaronM_NZ12-Jan-09 16:44
AaronM_NZ12-Jan-09 16:44 

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.