[SOLVED] very simpel Q, post or query(efficancy)

[rempires]

i just need to know which one of these is more efficient, post data or mysql queries.  There will be a lot of data and it will only be retrieved. I'm going to have a script were it will pull there data out of a mysql db, but when the page loads which it will do a lot would psot data or re-retrieving it form the datbase be the best route.  I'm think that post would be more efficient but i figured i'd ask because there will be a LOT LOT of data, and post has to send then receive were mysql sends the query and then receives.

[corbin]

So is this how (or atleast simliar to how) the page would work:

 

-User accesses page

-Server grabs MySQL data and populates a form with it

-User alters form

-User submits form

-Database is updated to reflect new data

 

If it's done that way, you will have to use post, but if users aren't changing data, then I don't know why you would use post.

 

Also, on a semi-random side note, if the web server and mysql server are on the same computer or even in a LAN, it will be much, much more effecient to query the MySQL database than using post simply because the transfer speed of data in a LAN is so much faster than it would be for the average user of your website.

[rempires]

thank you, that's not actually what's happening but the mysql and webserver are the same machine so that will work, thank you.