Re: CSV speed
| From: | Wolf | Date: | Tue, 11 Mar 2008 03:17:24 +0000 |
| Subject: | Re: CSV speed | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-271249@lists.php.net to get a copy of this message | ||
Greg Donald wrote:
On Mon, Mar 10, 2008 at 8:09 PM, Danny Brow <maillist@fullmotions.com> wrote:While that could work if the server is set up to allow you to run system calls, but you don't find that available outside of test environments. Also depending on the file sizes, you'll see some differences. WolfI have about 10 csv files I need to open to access data. It takes a lot of time to search each file for the values I need. Would it be best to just dump all the cvs files to an SQL db and then just grab what I need from there? I'm starting to think it would make a lot of sense. What do you guys think?grep foo whatever.csv | php ./script.php