Results 1 to 11 of 11
  1. #1
    Newbie
    Join Date
    February 14th, 2005
    Posts
    12
    Use CSV File directly for DataFeed
    My God! I find that I can not create my MYsql database on my server.

    So would someone tell me that if i can use CSV file directly.

    I use php to generate sites.

    I just use the funtion such as "fgetscsv","explode",
    And will it work??

  2. #2
    Not Verif-Lidated infoTim's Avatar
    Join Date
    January 18th, 2005
    Location
    Sunny Florida
    Posts
    1,021
    Will it work? Yes.

    Will it be slow? Yes, indeedy!
    Tim
    consultant by day, affiliate by night

  3. #3
    Roll Tide mobilebadboy's Avatar
    Join Date
    January 18th, 2005
    Location
    Mobile, Alabama
    Posts
    1,220
    Will it be slow? Yes, indeedy!
    Well, yes and no. No, if you parse it all out once and cache it. If you only update the csv every couple of weeks, then you can set a long cache time on it. No need to continually open the file and parse it all out.

    Shawn Kerr (.com) | Disney World | SEC Football

  4. #4
    Not Verif-Lidated infoTim's Avatar
    Join Date
    January 18th, 2005
    Location
    Sunny Florida
    Posts
    1,021
    Using the CSV to generate static pages or caching would do the trick for sure, but if all they're going to do is replace the databse with fgetcsv calls, it will be slow.
    Tim
    consultant by day, affiliate by night

  5. #5
    Newbie
    Join Date
    February 14th, 2005
    Posts
    12
    my god.
    it will be slow.,of course.

    And then No Sale will be generated,,,,,,,BAD,TOO BAD!!

    BTW, how about IPC,

  6. #6
    Not Verif-Lidated infoTim's Avatar
    Join Date
    January 18th, 2005
    Location
    Sunny Florida
    Posts
    1,021
    Is it that your web host does not support mySQL, or ???

    I know some (shared) hosts pre-create a database for you based on your account name and that's the only one you can use, i.e. you can't create one on your own.
    Tim
    consultant by day, affiliate by night

  7. #7
    ABW Ambassador Jane's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,350
    That is how my host is, I only have one database. But I can make as many different tables as I want. One for each merchant, what's the difference? I guess maybe it could run a bit slower that way?

  8. #8
    Newbie
    Join Date
    January 18th, 2005
    Posts
    7
    You can simulate a mysql with text file
    What do you think about this script:

    http://www.c-worker.ch/txtdbapi/index_eng.php

    thanks

  9. #9
    Newbie
    Join Date
    January 18th, 2005
    Posts
    13
    For small datafeeds, using a CSV file directly will usually be faster than using a MySQL database. This is because there's none of the overhead that's required in running the database software. How big is the datafeed?

    -Jason

  10. #10
    Newbie
    Join Date
    January 18th, 2005
    Posts
    7
    using csv file
    I would like to try this solution with less than 1000 lines/products...for shareasale or netshop or other I found here.

    Can I use csv with 2000 products?

    Thanks

  11. #11
    Member
    Join Date
    January 18th, 2005
    Posts
    64
    I think u can use tools like webmerge with your csv file to generate. But I would suggest using mysql, so that you can have a dynamic website !!

  12. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Import images to Adwords Editor via csv file?
    By referist in forum Search Engine Optimization
    Replies: 0
    Last Post: September 19th, 2010, 07:11 PM
  2. Replies: 0
    Last Post: April 24th, 2009, 09:31 AM
  3. CSV File instead of Webservices ?
    By Cosmo in forum Amazon
    Replies: 5
    Last Post: August 20th, 2004, 11:25 AM
  4. Getting data from CSV file into HTML Framed pages?
    By Happy in forum WebMerge (Fourthworld.com)
    Replies: 1
    Last Post: March 18th, 2004, 09:43 AM

Posting Permissions

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