VB.net Array vs SQL Temporary Tables

[Adam Maltby]

Hi,

I am writing a project which will extarct some random entries from an sql table and hold them for later use.

My question is:
Which would provide the best performance; Select the data with sql calls and hold the data a vb array or Select the data with sql calls and hold it in a temporary sql table?

Cheers
Adam

 

[Jorge]

Hi Adam
The SQl temporary tables are deleted when there no longer
used. So i would say holding the data in a array is
better.

Kind Regards
Jorge

-----Original Message-----
Hi,

I am writing a project which will extarct some random

entries from an sql table and hold them for later use.

My question is:
Which would provide the best performance; Select the

data with sql calls and hold the data a vb array or
Select the data with sql calls and hold it in a temporary
sql table?

 

[Adam Maltby]

Hi Jorge,

I know the temp table will be deleted when the spid ends - but that doesn't matter as the spid won't end until my app says so.... so this was purely from a speed performance point of view....

Cheers
Adam

 

[Jorge]

Hi
Then why not holding it insider a dataset ? If its just
for storing ?

Jorge

-----Original Message-----
Hi Jorge,

I know the temp table will be deleted when the spid

ends - but that doesn't matter as the spid won't end
until my app says so.... so this was purely from a speed
performance point of view....

 

[Cor Ligthert]

I am writing a project which will extarct some random entries from an sql

table and hold them >for later use.

My question is:
Which would provide the best performance; Select the data with sql calls

and hold the data a >vb array or Select the data with sql calls and hold it
in a temporary sql table?


That is where the dataset is designed for.

Cor