PDA

View Full Version : MySQL/PHP/Flash - Which is better for my LAN ap ?


Ricod
12-28-2001, 09:47 AM
I'm making a LAN app which is sort off an agenda / messageboard / chat combo (and maybe a simple game, just for the fun of it :) ) and am using MySQL as the back-end with some PHP. But I was wondering, is it better to do the processing in Flash or PHP. Is either faster, or does it kinda depend on the situation ? Or am I just blabbing here, clearly showing I know nothing about this ?
To clarify, here's what I'm wondering about :

Lets say I have to calculate some stuff out of 2 tables. I extract the data with PHP. There going to end up in Flash sooner or later, but do I make the calculations in PHP and send the results to Flash, or do I send the raw data to Flash and process it there ?
A few pointers would be very helpful. Thanks in advance !

tg
12-28-2001, 03:59 PM
if the processing is cpu intensive, do you want your server to process it...may be faster... may get to user quicker.... but do you want server cpu slowed down... bottlenecks traffic to your site...piss of users... never come back...? or do you want to do it on the client... may be slower...tie up the users cpu... piss them off... never come back...
*hehehe*

6 one way half dozen the other.

i did a lot of work on a client server app for a while, basically the original design had the app working 99% on the users box, with the server just handling db calls. the server was a good one (at the time) the user boxes were so-so. because of the design of the program we were getting problems sending data up and down our pipe, so i slowly started dismantling the app and do more processing on our server (so there was less/smaller recordsets going up and down the pipe). data flowed smoother, got to the user quicker, and db was able to release records quicker.

in this case i had a data intensive product with few/users hits on server. if i had a set up where i was getting lots of hits on the server and had less data to serve up, i may have done it differently.

Ricod
12-28-2001, 04:29 PM
Well there are only 15 employees here, so no heavy traffic. But smooth transitions are my main concern. Preferably the second someone changes something (like making an appointment) its displayed by all clients. Stuff like that. The clients are tiny 200mHZ units but the servers only 300mHZ. But ... there are plans for citrix usage ... so : Strong server coming up !

aumasta
12-28-2001, 05:05 PM
do yourself a fovour and write everything except the graphical backend in php.
with that traffic it won't be faster, but if you are experienced in php you can do the programming in no time

so long