Click here to Skip to main content
15,887,928 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
AnswerRe: How to make a Cloud text from database Pin
User 171649226-Oct-11 11:39
professionalUser 171649226-Oct-11 11:39 
QuestionFacebook-Like modal box Pin
Jassim Rahma25-Oct-11 6:26
Jassim Rahma25-Oct-11 6:26 
AnswerRe: Facebook-Like modal box Pin
Mohibur Rashid25-Oct-11 15:40
professionalMohibur Rashid25-Oct-11 15:40 
Questionsignature_invalid in Google API Pin
Paresh146225-Oct-11 2:36
Paresh146225-Oct-11 2:36 
AnswerRe: signature_invalid in Google API Pin
Niall Barr26-Oct-11 3:21
professionalNiall Barr26-Oct-11 3:21 
Questiondata was not displayed in the application in the correct format. Pin
Honeyboy_2025-Oct-11 1:01
Honeyboy_2025-Oct-11 1:01 
AnswerRe: data was not displayed in the application in the correct format. Pin
cjoki4-Nov-11 10:30
cjoki4-Nov-11 10:30 
QuestionBest Practices - mysql calls Pin
Dwayner7920-Oct-11 13:59
Dwayner7920-Oct-11 13:59 
I traditionally live in the client app world, so minimizing lines of code is more important than performance, so my coding style is heavy on common functions, etc.

Now that I am working on a web app (PHP and mySQL), I find myself second guessing everything. Here is an example. I am working on a shopping cart for an existing site. There are multiple places where the price of a particular product is returned:
Product Page
Cart over view
Buy process page,
receipt print,
etc.

In most cases, the product data (price) is already available, but the price can vary in different circumstances. I'm considering one function that gets passed the important variables, calculated the price of the product, and returns that price. However, to do so will require polling the database each time each price is requested (in some cases that is multiple prices on one page, so multiple calls to the database while the page is loading).

So my question is really one of best practice. How much of a noticeable performance hit does each call to the database take? Is it common to try to reduce the number of mysql calls? Do you not care? should each page have its own code, and just copy paste all over, and tweek each place where common data is shown?

There is a lot of how to questions (I have posted them) but I am hoping the community here can offer some more higher level theory.

Thank you in advance!
*****************
"We need to apply 21st-century information technology to the health care field. We need to have our medical records put on the I.T." —GW

AnswerRe: Best Practices - mysql calls Pin
Mohibur Rashid21-Oct-11 0:02
professionalMohibur Rashid21-Oct-11 0:02 
GeneralRe: Best Practices - mysql calls Pin
Dwayner7923-Oct-11 7:40
Dwayner7923-Oct-11 7:40 
GeneralRe: Best Practices - mysql calls Pin
Mohibur Rashid23-Oct-11 12:05
professionalMohibur Rashid23-Oct-11 12:05 
QuestionUsing MSSQL stored procedure with codeigniter Pin
noadek20-Oct-11 6:43
noadek20-Oct-11 6:43 
QuestionAverage Disk Queue Length In Linux Pin
ReaperDR17-Oct-11 2:52
ReaperDR17-Oct-11 2:52 
JokeRe: Average Disk Queue Length In Linux Pin
Albert Holguin17-Oct-11 4:00
professionalAlbert Holguin17-Oct-11 4:00 
GeneralRe: Average Disk Queue Length In Linux PinPopular
ReaperDR17-Oct-11 15:27
ReaperDR17-Oct-11 15:27 
JokeRe: Average Disk Queue Length In Linux Pin
AspDotNetDev14-Nov-11 10:03
protectorAspDotNetDev14-Nov-11 10:03 
QuestionVisual Studio for PHP!! Pin
Jassim Rahma16-Oct-11 5:00
Jassim Rahma16-Oct-11 5:00 
AnswerRe: Visual Studio for PHP!! Pin
Graham Breach16-Oct-11 5:12
Graham Breach16-Oct-11 5:12 
AnswerRe: Visual Studio for PHP!! Pin
Mohibur Rashid17-Oct-11 18:43
professionalMohibur Rashid17-Oct-11 18:43 
AnswerRe: Visual Studio for PHP!! Pin
User 171649217-Oct-11 22:27
professionalUser 171649217-Oct-11 22:27 
GeneralRe: Visual Studio for PHP!! Pin
Jassim Rahma19-Oct-11 0:11
Jassim Rahma19-Oct-11 0:11 
GeneralRe: Visual Studio for PHP!! Pin
User 171649219-Oct-11 1:13
professionalUser 171649219-Oct-11 1:13 
GeneralRe: Visual Studio for PHP!! Pin
Jassim Rahma19-Oct-11 1:49
Jassim Rahma19-Oct-11 1:49 
GeneralRe: Visual Studio for PHP!! Pin
User 171649219-Oct-11 2:00
professionalUser 171649219-Oct-11 2:00 
AnswerRe: Visual Studio for PHP!! Pin
Luc Pattyn19-Oct-11 1:59
sitebuilderLuc Pattyn19-Oct-11 1:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.