Click here to get back home

bulk load

 HomeNewsGroups | Search | About
 mailing.database.mysql    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
bulk load swethach 01-19-2007
Posted by swethach on January 19, 2007, 5:19 pm
Please log in for more thread options

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


Posted by Jeff North on January 19, 2007, 6:59 pm
Please log in for more thread options
On Fri, 19 Jan 2007 17:19:47 -0500, in mailing.database.mysql swethach

>|
>| 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
---------------------------------------------------------------

Similar ThreadsPosted
Bulk Rename - Best Practices? January 16, 2007, 3:29 pm
Bulk Insert of new records in sequence October 11, 2005, 7:49 pm
does "LOAD DATA" EVER work?!? I've tried EVERYTHING! November 22, 2005, 9:43 am
Load file errors February 27, 2006, 9:24 am
upgrade from 4.1 to 5.1 - load increased August 7, 2007, 4:12 pm
Re: LOAD FILE access problem February 26, 2006, 6:19 am
LOAD FILE access problem February 26, 2006, 5:43 am
Complex LOAD DATA INFILE May 18, 2006, 4:45 am
does "load index" help for fulltext search? August 4, 2006, 7:55 am
How to specify Date format during LOAD DATA INFILE ? June 27, 2005, 6:52 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap