linking -vs- importing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello,

can someone tell me if i would lose a great deal of efficiency by linking to
a large text file rather than importing it if i want to run queries off of
the file. the files are on my local hard drive but they are so large by
importing them i risk the chance of running over 2GB. I need to run simple
queries from them to generate customer data many times a day, by linking I
would save the time of importing the files but do i risk any performance by
just linking to them??????

thanks!!!
 
I think you have answered your own question. If importing the data would
trigger the 2GB limit, then importing is not an option. Yes, linking is
slower than using a local table, but if you can't handle the amount of data,
then linking is your only choice.
 
Back
Top