On Mon, 8 Apr 2002, Matthew Walker wrote:
> You definitely want to use MySQL for this. Ignore all those people who
> recommended text file DBs. They are /SLOW/. MySQL is very very fast.
I'll echo this. MySQL is hyperoptimized for this sort of transaction. It
already has the databases open so that
g about.
>
> You may well be best off using a database, either
> that or invest some
> serious thought into how you are going to handle
> multiple clients loading
> pages.
>
> Jason
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED
You definitely want to use MySQL for this. Ignore all those people who
recommended text file DBs. They are /SLOW/. MySQL is very very fast. To
show you a small sample of how fast, here's the debug data from one of
my scripts, showing how long the page took to generate, and how many
queries were ru
tiple clients loading
pages.
Jason
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 12:56 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] counter for HIGH traffic site
If it should be fast,
avoid using mysql, just write a file with your numbe
If it should be fast,
avoid using mysql, just write a file with your number,
if there´s a new request, get your number, add one and write it back.
So you avoid mysql-"SQL parsing", opening Database, searching data,
send to process, php putting in var...
just open, read, add, write, close
HTH O
You might also want to setup the table your updating the hits in
as a HASH type table which runs completely in RAM, and as a result
is extremely fast. The only obvious downside, is the data (or hits in this case)
are lost on reboot.
Adam Voigt
[EMAIL PROTECTED]
On Mon, 8 Apr 2002 09:41:39 -0700,
as long as you are only inserting information into the mysql db on each page
load, then you shouldn't have a problem. make sure you keep you indecies
down to a minimum.
Jim Lucas
- Original Message -
From: "Craig Westerman" <[EMAIL PROTECTED]>
To: "php-general-list" <[EMAIL PROTECTED]>
7 matches
Mail list logo
