Tag Archives: Optimization

An example for MySQL query optimization

When I developed an MySQL / PHP web application, I struggled to optimized the database queries to make the application more efficient. One thing we can do is to optimize the SQL queries in the application. Here is one simple … Continue reading

Share
Posted in MySQL | Tagged , , , , , | Leave a comment

Construction of objective function in optimization problem

Many optimization procedures require a single objective function. How to construct an efficient objective function in optimization problem is critical. On one side, we have multiple goals, how to create a single function to integrate all the goals together?  On … Continue reading

Share
Posted in Data analysis, Excel | Tagged , , , , , , | Leave a comment

Downhill Simplex Method in Multidimensions

In this article, C program of the downhill simplex method in Numeric Recipe in C – the Art if Scientific computing (Second Edition, Press, W.H., Teukolsky, S.A., Vetterling, W.T., Flannery, B.P., 1992, Cambridge University Press, New York) was translated into … Continue reading

Share
Posted in Data analysis, MATLAB | Tagged , , , | Leave a comment

Simple way to utilize Excel Solver

Excel Solver is a powerful tool to solve any nonlinear problem in Excel. Excel provide a interface to allow use to select options and fill target and parameters. If you only work on one set of data and explore multiple … Continue reading

Share
Posted in Excel, VBA/ASP | Tagged , , , , | 2 Comments