| From: | Adam Witney <awitney(at)sghms(dot)ac(dot)uk> |
|---|---|
| To: | Pierre-Fr=?ISO-8859-1?B?6WTp?=ric Caillaud <lists(at)boutiquenumerique(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Can COPY skip a header line? |
| Date: | 2004-11-23 10:46:11 |
| Message-ID: | BDC8C573.3C580%awitney@sghms.ac.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 19/11/04 6:46 pm, "Pierre-Frédéric Caillaud"
<lists(at)boutiquenumerique(dot)com> wrote:
>
>> can do this fine with small files.... But if I get above a 1000 rows it
>> takes so long it time out.
>
> PHP is slow, but not *that* slow, you have a problem somewhere !
Aha yes, I was reading the file doing this
fgets($fh, 1048576)))
... But changing it to
fgets($fh, 1024)))
Which is a large enough amount of data for my needs improved the speed
dramatically!
Thanks to all those that replied
adam
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Net Virtual Mailing Lists | 2004-11-23 10:47:27 | Re: Lexical question... |
| Previous Message | Woodchuck Bill | 2004-11-23 10:43:18 | Re: Google (was RFD: comp.databases.postgresql.*) |