-
Technology
Industry
-
Experience
- Testimonials
- "I would say that they are meeting/exceeding my expectations. They appear very capable and their high level of enthusiasm for the project is great."
- Senior QA manager
WAP Community based on LAMP structure
Project Overview
As the top digital media communication company in China, the client provides multimedia products and Internet related software solutions worldwide. Wireless Application Protocol, WAP, is an open international standard for application layer network communications in a wireless communication environment. It allows applications to access to the Internet from smartPhones, PDA or other mobile devices. WAP sites are written in, or dynamically converted to, Wireless Markup Language (WML) and accessed via the WAP browser. A WAP browser provides all of the basic services of a computer based web browser but simplified to operate within the restrictions of mobile devices.
Solutions
Our outsourcing WAP Community use LAMP (Linux + Apache + MySQL + PHP) as the main structure. PHP is considered the implementation of high efficiency and fast development and with the characteristics of good coding support. Over the years PHP and MySQL proved themselves out through numerous projects certified partners. Meantime the efficiency of MySQL is the reason for WAP Community to choose it as default database. Considering the stability and robust, Apache is adopted as the Front-end server.
Mobile browser is an especial client. It not only has the different models of mobile phones, browser types, unstable version, but also created confusion in poor coding performance and low performance characteristics. Based on 2 / 8 principles, the website should consider of the 80% users; all pages should be designed based on the WML 1.2 specification design rather than use non-standard WML labels, such as “<u >..</ u>”, “ <b> .. </ b>”. During the database design, we need pay more attention to performance and efficiency issues, because any of goal’s value, whether it is personal or societal, is only determined by weighing the benefits of achieving the goal against its costs – to us as well as others.
| 1. |
SELECT the regular operation and INSERT / UPDATE operation of two separate fields and it can be to a certain extent, avoid prolonged lock Table to cause other process failed connection. |
|
| 2. | Be careful of using parameter types of MySQL. The tremendous volume of data and very few characters in the content type field can be used with CHAR instead of VARCHAR, although this will be a waste of space, however, which could return good performance. | |
| 3. | Consider our knowledge of the Massive Data Sheet (record numbers of more than 1 million), which is to be taken to improve performance demolition table. The specific ID hash can be used with segmentation method or date segmentation method. | |
| 4. |
Similarly, consider the problem about N +1 enquiries / delete, and on SELECT operation as far as possible in the definition for field instead of "*" for all fields. |
Skype:unisoft-china
Submit request
Phone: +86 1062431711
Fax: +86 1062431800
E-mail: info@unisoftchina.com
- Outsourcing







