On Nov 24, 2007 2:32 AM, Jon Westcot [EMAIL PROTECTED] wrote:
Hi all:
For those who've been following the saga, I'm working on an application
that needs to load
a data file consisting of approximately 29,000 to 35,000 records in it (and
not short ones,
either) into several tables.
Eventually, I wind up with a query similar to:
UPDATE table_01 SET field_a = 'New value here', updated=CURDATE() WHERE
primary_key=12345
Even though you've solved it one way to work out the problem here would
be to change it to a select query (unfortunately mysql can't explain
-Original Message-
From: Jon Westcot [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 24, 2007 4:32 AM
To: PHP General
Subject: [PHP] Performance question for table updating
Hi all:
For those who've been following the saga, I'm working on an
application that needs to load
Hi Rob, et al.:
- Original Message -
From: Andrés Robinet [EMAIL PROTECTED]
-Original Message-
From: Jon Westcot [mailto:[EMAIL PROTECTED]
:: gigantic snip here::
So, long story short (oops -- too late!), what's the concensus
among the learned assembly here? Is
Could there be some performance gain by uploading the data to another table and
then update / insert via sql?
bastien
From: [EMAIL PROTECTED]
To: php-general@lists.php.net
Date: Sat, 24 Nov 2007 04:03:53 -0700
Subject: Re: [PHP] Performance question
On Sat, 2007-11-24 at 04:03 -0700, Jon Westcot wrote:
Moral of the story? Two, really. First, ensure you always reference
values in the way most appropriate for their type. Second, don't make your
idiocy public by asking stupid questions on a public forum. g What's the
quote
Hi all:
For those who've been following the saga, I'm working on an application
that needs to load a data file consisting of approximately 29,000 to 35,000
records in it (and not short ones, either) into several tables. I'm using
MySQL as the database.
I've noticed a really horrible
This is more a How would you do it than a How can i do it question.
Didn't have time to try it, but i want to know how mysql_seek_row acts
with large result sets.
For example im thinking of building a node tree application that can
have dual direction links to nodes attached to different
I think this might interest you:
http://www.bluerwhite.org/btree/
then again it may make your ears bleed (because of the Maths :-).
Mathieu Dumoulin wrote:
This is more a How would you do it than a How can i do it question.
Didn't have time to try it, but i want to know how mysql_seek_row
B trees or binary trees or hash tables or wathever sort algo or memory
organisation could be just great if i'd put all my data in the page and
tried or needed to sort it, but i can't do that and don't really need to.
I'm actually searching for a way to load a ton of data from mysql but
This is more a How would you do it than a How can i do it question.
Didn't have time to try it, but i want to know how mysql_seek_row
acts with large result sets.
For example im thinking of building a node tree application that can
have dual direction links to nodes attached to different
At 12:02 PM 2/1/2006, Mathieu Dumoulin wrote:
This is more a How would you do it than a How can i do it question.
Didn't have time to try it, but i want to know how mysql_seek_row acts
with large result sets.
For example im thinking of building a node tree application that can have
dual
Miles Thompson wrote:
At 12:02 PM 2/1/2006, Mathieu Dumoulin wrote:
This is more a How would you do it than a How can i do it question.
Didn't have time to try it, but i want to know how mysql_seek_row acts
with large result sets.
For example im thinking of building a node tree application
Hi,
Any time you fetch results from a database it take up memory, you can't
do much about that (you can limit the effect by using 'limit' in
conjunction with paging and only getting the columns you need etc but
that's about it).
If you're using a standard id/parentid type approach you're
: Anders Norrbring [mailto:[EMAIL PROTECTED]
Inviato: lunedì 5 dicembre 2005 8.27
A: PHP General
Oggetto: [PHP] Performance question
I've been spending some time to find performance pros and cons, but so far
haven't had any real luck.
Can someone on this list say which is better than the other
:[EMAIL PROTECTED]
Inviato: lunedì 5 dicembre 2005 8.27
A: PHP General
Oggetto: [PHP] Performance question
I've been spending some time to find performance pros and cons, but so far
haven't had any real luck.
Can someone on this list say which is better than the other, and also why,
when it comes
I've been spending some time to find performance pros and cons, but so
far haven't had any real luck.
Can someone on this list say which is better than the other, and also
why, when it comes to these kinds of syntax:
1.
php code
?
html statements?= $variable ?/end tag
tag?= $var2 ?/end tag
on 25/06/03 12:19 PM, Ow Mun Heng ([EMAIL PROTECTED]) wrote:
Can someone help explain how I can perform a benchmark on the queries or
whatever?
Write some code, run it many many times, time it with something like Example
1 on http://au.php.net/microtime, then write alternate code, run it many
PROTECTED]
Subject: RE: [PHP] Performance question
It depends on your HW / Application / number of visitors.
If you are planning to have many visitors and plan this number to
constantly
grow than you should avoid going to the DB as much as possible.
Sincerely
berber
Visit http
On Jun 25, 2003, Ow Mun Heng claimed that:
|Can someone help explain how I can perform a benchmark on the queries or
|whatever?
|
|
|Cheers,
|Mun Heng, Ow
|H/M Engineering
|Western Digital M'sia
|DID : 03-7870 5168
|
|
Do it many times and time it.
--
Registered Linux user #304026.
lynx -source
Hi Group,
I have a question regarding retrieving the
information. I have the functionlity in which on every
user click, system needs to retrieve information for
particular user and display the page according to the
retrieved information. Now question is which is the
scalable solution? (1)
I have a question regarding retrieving the
information. I have the functionlity in which on every
user click, system needs to retrieve information for
particular user and display the page according to the
retrieved information. Now question is which is the
scalable solution? (1) Retrieve
tomorrow.
-Original Message-
From: Hardik Doshi [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 5:10 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Performance question
Hi Group,
I have a question regarding retrieving the
information. I have the functionlity in which on every
user click
What's the difference in performance between
print( file_get_contents(myfile.html) );
and
include(myfile.html);
is there any particular reason for using one over the other?
Patrick
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
PROTECTED]
Subject: [PHP] Performance Question
What's the difference in performance between
print( file_get_contents(myfile.html) );
and
include(myfile.html);
is there any particular reason for using one over the other?
Patrick
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe
Ok I have a performance question. I run a wallpaper site; this is the url to
the main gallery page http://www.cognitivedistortion.com/php/gal.php
http://www.cognitivedistortion.com/php/gal.php The page does a dir read
and lists all pictures found in each directory, it does this every time the
]]
Sent: Tuesday, April 16, 2002 11:22 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Performance question
Ok I have a performance question. I run a wallpaper site; this is the url to
the main gallery page http://www.cognitivedistortion.com/php/gal.php
http://www.cognitivedistortion.com/php/gal.php
PROTECTED]
Subject: [PHP] Performance question
Ok I have a performance question. I run a wallpaper site; this is the url to
the main gallery page http://www.cognitivedistortion.com/php/gal.php
http://www.cognitivedistortion.com/php/gal.php The page does a dir read
and lists all pictures found in each
Hi!
I have a page that uses server-side includes to display different
features. Something like this:
html
!--#include virtual=feature1.php-- (a few db calls)
!--#include virtual=feature2.cgi-- (perl-script with db calls)
!--#include virtual=feature3.php-- (even more db calls)
/html
If
Hi!
I have a page that uses server-side includes to display different
features. Something like this:
html
!--#include virtual=feature1.php-- (a few db calls)
!--#include virtual=feature2.cgi-- (perl-script with db calls)
!--#include virtual=feature3.php-- (even more db calls)
/html
Hello all.
I was wondering. What kind of performance reduction is there in including
files or using the auto prepended one for a file less than, say, 10 line?
Specifically, I would think that the file IO would be a detriment to such
a small file. Without the includes, code would be repeated,
"Matthew Mundy" [EMAIL PROTECTED] wrote:
I was wondering. What kind of performance reduction is there in including
files or using the auto prepended one for a file less than, say, 10 line?
Specifically, I would think that the file IO would be a detriment to such
a small file. Without the
Do I pay a performance penality for calling a file that only contains html
code .php or .php3? In otherwords what is the php parser overhead if there
is no php code in the file?
John Guynn
This email brought to you by RFCs 821 and 1225.
--
PHP General Mailing List (http://www.php.net/)
To
33 matches
Mail list logo