Jon Westcot wrote:
> Hi Chris:
>
...
> That is, I need to close the single quote, place a comma after the
> field, and then add in another opening quote. One other thing: I suspect I
> need to use addslashes() to the elements in $data -- is there a way to do
> this with one statement as you
Hi Chris:
> What indexes are on this table?
On the import table, there is only one index. And I probably don't even
need an index on it since it will be processed sequentially into other
tables after it's been imported.
> When you do an insert, each one has to update the index
> as well as
Jon Westcot wrote:
Hi David, et al.:
Thanks for the comment. I removed the trailing semi-colon in the two
areas where it was being sent to mysql_query() and tried the code again.
I'm still getting the same basic problem -- it silently aborts somewhere
around 22,000 to 26,000 records being p
Jon,
I can provide you with access to a Linux web box to test your code
and database stuff if you'd like. No charge or anything, it's just
that I strongly believe the problems are caused by the limits you face
with your current web host. If you want to give it a shot, let me
know and I'l
> Thanks for the comment. I removed the trailing semi-colon in the two
> areas where it was being sent to mysql_query() and tried the code again.
> I'm still getting the same basic problem -- it silently aborts somewhere
> around 22,000 to 26,000 records being processed out of just under 30,000.
>
Hi David, et al.:
Thanks for the comment. I removed the trailing semi-colon in the two
areas where it was being sent to mysql_query() and tried the code again.
I'm still getting the same basic problem -- it silently aborts somewhere
around 22,000 to 26,000 records being processed out of just
On 11/5/07, Jon Westcot <[EMAIL PROTECTED]> wrote:
> Hi all:
>
>As requested, here's the code:
>
> if(isset($_POST['process'])){
>$old_session_gc_maxlifetime = "";
>$old_max_execution_time = "";
>$old_max_input_time = "";
>$old_session_gc_maxlifetime = ini_set("session.gc_maxl
Jon Westcot wrote:
> Hi all:
just show us the code.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On 11/5/07, Jon Westcot <[EMAIL PROTECTED]> wrote:
> I'm really starting to hate shared servers.
In general, keep in mind that a shared server is for low-level
activities. If you're doing something that big, you may want to move
to a VPS, a smaller hosting company such as PilotPig.net, wh
Hi Kristen:
> I'm jumping in here late, so I haven't seen previous posts. Another
> possible place I have seen limiting post/upload sizes:
>
> There is an Apache directive called LimitRequestSize or somesuch which
will
> take precedence (silently) over any PHP max post size you set. I found
this
Hi Instruct ICC:
> > How do I save the individual query statements to a file? That may give
> > me a good option for checking a "log" of activity when the process fails
> > again.
>
> I'm assuming you are building an $sql variable, so you would write that to
> a file instead of executing it in a q
Monday, November 05, 2007 2:20 PM
Subject: Re: [PHP] More info on timeout problem
> One thing to note, if you have not upped the max file size to be over what
you are trying to load, the server will hang.
>
> ;;;
> ; Resource Limits ;
> ;;;
>
>
One thing to note, if you have not upped the max file size to be over what you
are trying to load, the server will hang.
;;;
; Resource Limits ;
;;;
max_execution_time = 7200 ; Maximum execution time of each script, in
seconds
max_input_time = 7200 ; Maximu
-Original Message-
From: Instruct ICC [mailto:[EMAIL PROTECTED]
Sent: Monday, November 05, 2007 3:34 PM
To: php-general@lists.php.net
Subject: RE: [PHP] More info on timeout problem
> Sounds much like what I'm trying to do. I have had to give up, for the
> time being, on u
> Sounds much like what I'm trying to do. I have had to give up, for the
> time being, on using PHP to upload the datafile; it's about 56 MB in size
> and nothing I do seems to let me upload anything larger than a 2MB file. :(
I don't know if it's been mentioned in this thread, but 2M is a defaul
Hi Instruct ICC:
> > I'm now wondering if some error is occurring that, for some reason,
is
> > silently ending the routine. I'm building what may be a very long SQL
> > INSERT statement for each line in the CSV file that I'm reading; could
> > I be hitting some upper limit for the length of
> I'm now wondering if some error is occurring that, for some reason, is
> silently ending the routine. I'm building what may be a very long SQL INSERT
> statement for each line in the CSV file that I'm reading; could I be hitting
> some upper limit for the length of the SQL code? I'd thi
17 matches
Mail list logo
