Static php sites. Read more...

[Rooster]

Hi,
i am new and i read a lot about MySQL performance and so on.
Most people say: " The vB crashes about 200-300 Useres"

Not very much :(

That?s why ...
I would like to have a php build script, which can build (after switching a button in the admin) a static php board in another folder. This is for reading only. The only dynamic stuff people can choose is the search feature.

The php build script should generate a file structure of the board from the last xy days from the MySQL Database.

The look is the same as a normal dynamic vB, but it will only updated, if the admin or mod switch the "building button" in the Admin Center.


Why i need it ?
The "statitic board" can handle much more Users at the same time. I don?t need the board for discussing, i need it as a reading board and for some members also as a publish board.


Got me ?
Can you help me ?

Sorry for my english

Rooster


P.S. Links2 is using such a building script. Generates an html structure from the database.

Website of Links2:
http://www.gossamer-threads.com/scripts/links/index.htm
AdminCenter of Links2 (you can see the building feature)
http://www.gossamer-threads.com/perl/links/admin/admin.cgi

[Rooster]

bump :)

[cliffe2]

It should generate a new html page if a reply is posted if you want it fully enjoyable,

but then you will lose a lot of customizable things from the users side + how to handle new/old markers etc?

[Mentor]

This is just like the UBB 5. I really suggest aginst this, and as it would require a LARGE LARGE LARGE hack, i would just hack it to port like sybase, or another GOOD database.

[Rooster]

Nono, don?t wanna use UBB.
I wanna use vB ...

I have no idea how i can use sybase with a vb.
No Idea. My hoster has mySQL only.

This sounds very complicated and expencive for me :(

I need this hack so badly, cause i have many people who are only allowed to read the board. 300 People active at the same time is to less.

Chears

[Rooster]

Originally posted by cliffe2
It should generate a new html page if a reply is posted if you want it fully enjoyable,

but then you will lose a lot of customizable things from the users side + how to handle new/old markers etc?

Nope..don?t wanna this... this takes to much cpu power ...
I wanna switch a button only one time a day and all is build new from the database (html oder php pages) . ( Or a automatic process) Php pages are better, cause you can compress them.


The normal user should only read, search new posts, look profiles... thats all...

[chad]

Sound like you might want to look into a caching program for php... would be less work in the long run and would cache more than just your boards.

Also, I have yet to see a huge strain on the mySQL server from running vB.

[ldydvr]

Rooster,

If you're looking for speed and stability and you are using "Links" I would strongly utge you to look at "HyperSeek 2k"...

I am not associated with them at all but have used both systems and must warn you that links is a MAJOR hog and buggy drain. It is a MUCH more mature product on top of everything else!

It wont take but a second to see the number of people using it and you would be blow away at the number of people using it that used to use Links and dropped it like a bad habbit.

Just my $0.02

=-)

[tubedogg]

Originally posted by Rooster
Most people say: " The vB crashes about 200-300 Useres"I have never heard anyone say that...MySQL has a practical limit of about 700 users, but I have never heard anyone who had the proper hardware to support it say 200 or 300 concurrent users crashes vB.

The problem I see with your system is what gets rebuilt once a day? Everything? So threads with new posts don't have the new posts till the next day? To do it right you'd have to rebuild the thread page every time a post was made, which would not be easy or good on a server.