bulk load

Hi ...
I have a data file and I need to retrieve just two values from the
file. The positions of those values however remain the same in each
time. Is it better to load the complete file onto the database and then
retreive the two values out of it or is it better to load just those two
values on to the table.

Please suggest me.

Thanks in anticipation,
swetha


--
swethach
------------------------------------------------------------ ------------
swethach's Profile: http://techiegroups.com/member.php?userid=2183
View this thread: http://www.techiegroups.com/showthread.php?t=125354

Re: bulk load

On Fri, 19 Jan 2007 17:19:47 -0500, in mailing.database.mysql swethach

wrote:

>|
>| Hi ...
>| I have a data file and I need to retrieve just two values from the
>| file. The positions of those values however remain the same in each
>| time. Is it better to load the complete file onto the database and then
>| retreive the two values out of it or is it better to load just those two
>| values on to the table.
>|
>| Please suggest me.

Depends.
Where are these values located within the file, start, middle end.
How large is the data file?
Are the records fixed with or variable width?
------------------------------------------------------------ ---
jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
------------------------------------------------------------ ---