Results 1 to 4 of 4

Thread: Large table and downloading

  1. #1
    Registered
    Join Date
    May 2003
    Location
    Southern California, USA
    Posts
    46

    Large table and downloading

    Hi

    I have one table and I keep adding more data to the end of it everyday (20000 rows now). It becomes large so I zipped it before I download from hosting to my computer at home which is slow - takes several hours to download. It's still a 100MB zip file. Should I stop adding to this table, and create another new table for adding data to it?

    Thanks,

    John

  2. #2
    Administrator Chris's Avatar
    Join Date
    Feb 2003
    Location
    East Lansing, MI USA
    Posts
    7,049
    No, thats not good database design.

    I have a 200mb table that I've thought about doing that with before, its not a good idea though.
    Chris Beasley - My Guide to Building a Successful Website[size=1]
    Content Sites: ABCDFGHIJKLMNOP|Forums: ABCD EF|Ecommerce: Swords Knives

  3. #3
    Registered
    Join Date
    May 2003
    Location
    Southern California, USA
    Posts
    46
    Thanks. Problem is it will take longer and longer time to down load a large and become-more-larger table. I use ws-ftp to download. What is the fastest way to download large table?

    Thanks.

  4. #4
    Administrator Chris's Avatar
    Join Date
    Feb 2003
    Location
    East Lansing, MI USA
    Posts
    7,049
    Well I can download mine in 15 minutes, you should get broadband.
    Chris Beasley - My Guide to Building a Successful Website[size=1]
    Content Sites: ABCDFGHIJKLMNOP|Forums: ABCD EF|Ecommerce: Swords Knives

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •