k8oylos — Fri, 13 Jun 2003 22:10:01 +0000

How do i cache the data in a table? Would i have to update if manually? Cos the whole question is about automating the whole thing. It would be impossible for exemple to handle manually the latest forum posts

ROB — Fri, 13 Jun 2003 06:46:46 +0000

mysql to 4.0 caches common queries in memory, simply upgrading should solve your problems.

if you can't upgrade, you can cache the data in a single table and retrieve it with a single query. just make sure you empty it out any time the data changes.

mairving — Thu, 12 Jun 2003 19:56:45 +0000

Quote: Originally posted by k8oylos
I just took a look on google on cron job, and it said it needs shell access to run one. Does this mean that i need shell access on my server?

Some of the site managers like Cpanel have a cron job function. Otherwise, you would have to have shell access via telnet or SSH.

k8oylos — Thu, 12 Jun 2003 18:36:20 +0000

I just took a look on google on cron job, and it said it needs shell access to run one. Does this mean that i need shell access on my server?

k8oylos — Thu, 12 Jun 2003 18:21:32 +0000

Hey hey hey i am totally lost.
First of all i use php, but i am just an amateur and quite new to it.

Now i have no idea what Java Beans is, and i would prefer to leave it aside if there is no other solution.

moving to a better host? yes i am thinking of it indeed, but as i said, i am just an amateur doing it for fun, so no income-->not much money on server bills!

The other two now.
Cronjob. Another new word for me, but if what i understood is right it could do the job well. i want basically queries like top and latest forum posts, latest downloads and articles and it wouldn't really matter if it didn't update on the spot.
Where can i find more on cronjob (tutorial or whatever)?

And finally
Basically, when the script adds another article (or whatever) to the database, you append (or prepend) it to your static include file, and remove the oldest one. This is more work for you, but it wont query when not necessary and will update as soon as new content is posted.
Didn't quite get this. And where is it on phpbuilder.com?

And since i mentioned phpbuilder, i saw an article at them regarding putting php content in html page via javascript. Does this have any effect on speed?

nicora — Thu, 12 Jun 2003 15:21:09 +0000

What Server-side langauge are you using? php, asp, cfm ?

mairving — Thu, 12 Jun 2003 12:27:36 +0000

I have seen it done on phpbuilder's site, I believe. Their's is probably a forum hack.

Mark Hensler — Thu, 12 Jun 2003 09:23:28 +0000

I don't think he needs this for a search engine. Sounds more like forum hacks.

I would probably keep the latest info in a seperate file which you could include where desired. As for getting information into the file...

I don't like option 1. Doesn't feel right. Requires session management, etc. etc. Just too much messy.

Cron. Good idea. Not the best. It will query when it doen't need to, and won't update the content as soon as changes are made.

My suggestion is to hack the files which are use to post topics, threads, articles, and whatever else you want to track. Basically, when the script adds another article (or whatever) to the database, you append (or prepend) it to your static include file, and remove the oldest one. This is more work for you, but it wont query when not necessary and will update as soon as new content is posted.

zollet — Thu, 12 Jun 2003 05:17:15 +0000

As Suzanne mentioned, you could create a cron job that would basically run a PHP script that would build HTML pages based on the common searches. Then your script would check to see if the user does a common search and redirect them to a HTML page, if not then query the database.

...OR...

...you could simply move to a new and better web host

Cheers.

Suzanne — Thu, 12 Jun 2003 00:54:24 +0000

Java Beans will do this for you. Or you can manually do the more common searches yourself (setting them up, I mean) and use a php script to update them as needed.

So, yes.

For the php script, you would create a cronjob to run the script at whatever intervals you chose.