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 tab
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
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. What's the
> quote (prob
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]
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 as
> -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 need
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 st
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 applicat
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
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
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
avoidin
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
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
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 -sourc
EMAIL 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
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://www.weberdev.com/ Today!!!
To see where PHP might take you tomorrow
> 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) Retriev
I think that file_get_contents() is quicker, since include() runs what it
gets as normal php code. And that gives you the answer to the other question
as well. :)
Niklas
-Original Message-
From: Patrick Teague [mailto:[EMAIL PROTECTED]
Sent: 4. maaliskuuta 2003 10:57
To: [EMAIL PROTECT
I think you've got the best set up already. I have a PDF library that I do a
similar thing with. To update the site I just dump the new PDF's into their
directory and the users reload the page to see the new content.
James
-Original Message-
From: Fifield, Mike [mailto:[EMAIL PROTECTED]]
> Hi!
>
> I have a page that uses server-side includes to display different
> features. Something like this:
>
>(a few db calls)
>(perl-script with db calls)
>(even more db calls)
>
>
> If everything is embedded in a php-page I assume that the parser would
> start only once, and that
"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 t
""Chris Lee"" <[EMAIL PROTECTED]> wrote in message
93l3qd$p98$[EMAIL PROTECTED]">news:93l3qd$p98$[EMAIL PROTECTED]...
> has anyone ran any test to see what kind of performance hit? I know people
> are allways ranting and raving about single or double quotes regarding
> performance and people rant
has anyone ran any test to see what kind of performance hit? I know people
are allways ranting and raving about single or double quotes regarding
performance and people ranting and raving about HTML in or out of echo
statements.
the performance hit just isnt amazing, use what you want I figure, u
At 2:22 PM -0500 1/11/01, Ignacio Vazquez-Abrams wrote:
>On Thu, 11 Jan 2001, John Guynn wrote:
>
> > 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?
> >
> > J
On Thu, 11 Jan 2001, John Guynn wrote:
> 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.
>
Yes
25 matches
Mail list logo