It would also be very good to look at what other similar
web application are doing and learn from their success and mistake.
I am thinking about phpnuke, phpslice, slashdot and the likes...

py


----- Original Message -----
From: Conor McTernan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 8:02 AM
Subject: Re: [PHP] Re: (another, not entirely)sessions question


>
>
> On Fri, Jul 20, 2001 at 11:52:36AM +0000, Er Galv„o Abbott wrote:
> > Just a sugestion here, that may sound strange, but I'd do it like
> > this:
> >
> > Why don't you keep a simle text-counter file for each user? Why this
> > HAVE to go trough SQL?
>
> i suppose i want it to go through SQL because I am storing all my
> documents and the guts of the site in a database.
>
>
> > Just creat a text file with "0" on it. When the user posts, retrieve
> > the number from the file, increment it and then write it back...
>
> hmmm, interesting idea, but what happens when there are multiple users,
> each one will then have their own file, i know it wont take up too much
> disk space, but i really have a thing for tidy directorys:) and this
> sounds like a nightmare to me ;)
>
> >
> > This way you don't overload SQL and keep the post counter running...
>
>  could it in fact create more work for the CPU, if it has to keep reading
> and writing to files on the disk, as well, would that be any quicker?
>
>
>
> > Tell me what you think, even if you think it's stupid :)
>
> haha, i wouldnt say it's stupid anyway, but i wouldnt be attracted to that
> approach, i'm usually drawn to databases, hehe.
>
> >
> >
> > On Fri, 20 Jul 2001 12:31:15 +0100, [EMAIL PROTECTED] (Conor
> > McTernan) wrote:
> >
> > >Hey there,
> > >
> > >I'm currently writing a web app using php. I was just looking for some
> > >advice on one aspect. On this site, users will be able to log in and
post
> > >messages, or articles, or replies etc, you get the idea.
> > >
> > >Anyway, I am storing some info about the users, the usual stuff, name,
> > >email, password, all in mysql. I am also storing other info, such as
when
> > >they last posted, and how many times they have posted.
> > >
> > >When a user posts a new message, the message is sent to mysql and
stored
> > >in a table, at the same time, i also have to increment their total
number
> > >of posts. The way this is done is by selecting the posts field on their
> > >userid, which i have to find using their username, which is set as a
> > >session var, when the user logs in. This all results in a good few
> > >queries to mysql.
> > >
> > >I was wondering would it be better to load all the user info, e.g.
number
> > >of posts, last post date, into session vars, or should i set a cookie
on
> > >the client side, or should i just continue with the queries.
> > >
> > >Any help is appreciated.
> > >
> > >conor
> >
> >        Er Galv„o Abbott
> >          Webdeveloper
> >   [EMAIL PROTECTED]
> > ---------------------------------
> > To send me an e-mail just remove
> > the CAPITAL TEXT.
> > ---------------------------------
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to