Tips for Optimizing MySQL Queries (That don’t suck)

The rule in any situation where you want to opimize some code is that you first profile it and then find the bottlenecks. Mr. Silverton, however, aims right for the tippy top of the trees. I’d say 60% of database optimization is properly understanding SQL and the basics of databases. You need to understand joins vs. subselects, column indices, how to normalize data, etc. The next 35% is understanding the performance characteristics of your database of choice. COUNT(*) in MySQL, for example, can either be almost-free or painfully slow depending on which storage engine you’re using. Other things to consider: under what conditions does your database...
Read more »

Posted in: ,

Web Applications Security

At my present job I am responsible for web applications administration and security. I lead automation team in all implementation aspects, including project management, process analysis, workflow design, configuration data set-up, systems interface development, system installation, testing, training, go-live, and post-implementation monitoring. One of the major challanges in web applications domain is web development security. There are lots of web applications security risks. This post summarizes top ten web applications security risks for the year 2010 identified by The Open Web Application Security Project (OWASP). 1. Injection Injection...
Read more »

Posted in: ,,

Structure of a program C++

Probably the best way to start learning a programming language is by writing a program. Therefore, here is our first program:  1 2 3 4 5 6 7 8 9 10// my first program in C++ #include <iostream> using namespace std; int main () { cout << "Hello World!"; return 0; }Hello World! The first panel (in light blue) shows the source code for our first program. The second one (in light gray) shows the result of the program once compiled and executed. To the left, the grey numbers represent the line numbers - these are not part of the program, and are shown here merely for informational purposes. The way to edit and compile...
Read more »

Posted in: ,,

Free Download Source Code Visual Basic

All the files are zip files so you require a version of Winzip before you can load them up. Inside the zip you will find *.vbp , *.frm , *.bas these can just be loaded in Visual Basic. New Source Code: Typing and display text in reverse at real time Easy Source Code: Typing and display text in reverse at real time Yet another tic tac toe program Copying files from one place to another showing the windows move box Letting the user click to draw with another line joining them together Shows the memory available with additional information Moves the form to the position clicked Shows whether the user is connected by the internet...
Read more »

Posted in: ,

Development Environment Visual Basic

Learning the ins and outs of the Development Environment before you learn visual basic is somewhat like learning for a test you must know where all the functions belong and what their purpose is. First we will start with labelling the development environment. The above diagram shows the development environment with all the important points labelled. Many of Visual basic functions work similar to Microsoft word eg the Tool Bar and the tool box is similar to other products on the market which work off a single click then drag the width of the object required. The Tool Box contains the control you placed on the form window. All of the controls...
Read more »

Posted in: ,

Tool box Visual Basic

You may have noticed that when you click on different controls the Properties Window changes slightly this is due to different controls having different functions. Therefore more options are needed for example if you had a picture then you want to show an image. But if you wanted to open a internet connection you would have to fill in the remote host and other such settings. When you use the command () you will find that a new set of properties come up the following will provide a description and a property. ...
Read more »

Posted in: ,

6 Ways to Speed up your PC

By following a few simple guidelines, you can maintain your computer, help increase your PC speed, and help keep it running smoothly. This article discusses how to use the tools available in Windows 7, Windows Vista, and Windows XP Service Pack 3 to help make your computer faster, maintain your computer efficiently, and help safeguard your privacy when you're online. Note: Some of the tools mentioned in this article require you to be logged on as an administrator. If you aren't logged on as an administrator, you can only change settings that apply to your user account. 1. Remove spyware, and help protect your computer from viruses Spyware...
Read more »

Posted in: ,

MySQL Programming Languages

The most popular relational database manager is installed on 11 million servers in 2009. Acquired by Sun in 2008 he became after the takeover by Oracle of Sun, ownership of the former, and one wonders about its future. Brief history MySQL was created in 1995 by David Axmark, Allan Larsson and Michael Widenius who founded the company MySQL AB to market it. In June 2000 it passed under the GPL. The company was acquired by Sun on February 26 2008. Which was itself acquired by Oracle on 20 April 2009. Design MySQL is optimized for reading, it is well suited for the Web where viewing pages is more frequent than their creation or update....
Read more »

Posted in: ,

PHP Programming Languages

PHP was designed in 1995 by Rasmus Lerdorf because it needs a free tools to program Web pages and released under the name PHP/FI, (Personal Home Pages / Form Interpreter),. He has developped it further with the help of other programmers and made it open source for the community of users. A new engine was created for PHP 3 and a new name given: PHP Hypertext Preprocessor in 1997. The Zend engine was created in 1999 for PHP 4. PHP 5 was released in 2004, it is more object-oriented and supports XML. A PHP script produces web pages, and may be embedded inside HTML code as JavaScript but works server side. It is similar to C, but dynamic variables...
Read more »

Posted in: ,

Pascal Programming Languages

Pascal was designed in 1970 by Nicklaus Wirth to impose programmers a structured programming style. Pascal has successors, Modula and Oberon, which add module and access to system resources. But because these features has been added to Pascal itself by implementors, mainly Borland, the successors have not succeded. Pascal is used to teach programming. The main commercial port is Delphi, followed by Kylix. Features - strictly structured programming. - imports allows including functions from external modules, with no headers required as in C. - procedures and functions, the formers returning values. - objects added further. Why use Pascal? It...
Read more »

Posted in: ,

Free Download C to C++ Converter

Made in 2001 by Denis Sureau, convert sources of a C project to C++. Written in Python, it runs on any system. GNU GPL license. Requires Python 2.x. Features Script that translates C to C++ in some steps: generating classes, converting functions to methods, replacing calls to functions by references to methods. The main script calls other specialized ones but you can also proceed step by step and modify manually the results of a step before to start the next one. This tool is not easy to use. It is for experienced programmers. Why use it? Converting your project to C++ prevent conflits in identifiers, and ease to reuse your code. Requirements You...
Read more »

Posted in: ,

Free Download Borland C++ Compiler version 5.5

Borland C++ Compiler version 5.5 Free Download - AVAILABLE NOW Our classic ANSI C/C++ compiler technology, the Borland. C++ 5.5 Compiler and associated command line tools, is now available for free download on our Web site. Before you download the free C++ compiler, we encourage you to download a trial of C++Builder, our latest C++ development environment for Windows. C++Builder includes our newest C++ compiler with new C++0x support and Boost Libraries, code editor, local and remote debugging, visual designers, database connectivity, Windows 7 and touch/gesture support, and much, much more. The Borland C++ 5.5 Compiler is the high performance...
Read more »

Posted in: ,

C++ For system programming

C++, created in 1981 by Bjarne Stroutstup, adds object features to C, while remaining compatible with it. The goal of C++ goals was to be portable. C++ is an ISO standard named C++ 98. A new version will succeed in 2009, it will be C++ 09 and its main features are defined. Features C++ describes classes into header files, and body of methods into source files. By declaring instances of classes you can reuses set of variables and methods without to define them again. Memory management is unchanged. Overloading allows to declare a method with different parameters. Classes inherits one from other and share their methods. Why use C++? I...
Read more »

Posted in: ,

HTML (hypertext markup language)

HTML, the hypertext markup language is a subset of SGML, (invented by IBM in 1969) defined by the W3C consortium. It is a document description language, that uses tags for properties. This is the format recognized by web browsers. DHTML, dynamic HTML, is the combination of HTML and JavaScript. The CSS, cascading style sheet, adds the style sheet feature of word processor to HTML. Features - Tag based, uses < > for delimiters. - Unrecognized statements are ignored. - Unlimited embedding of constructs. Why use HTML? Writing web pages, but is also a standard format for any documents displayable locally by a web browser or a recent word...
Read more »

Posted in: ,

The Pascal Architecture

Pascal is a strongly typed, block structured programming language. The "type" of a Pascal variable consists of its semantic nature and its range of values, and can be expressed by a type name, an explicit value range, or a combination thereof. The range of values for a type is defined by the language itself for built-in types, or by the programmer for programmer defined types. Programmer-defined types are unique data types defined within the Pascal TYPE declaration section, and can consist of enumerated types, arrays, records, pointers, sets, and more, as well as combinations thereof. When variables are declared as one type, the compiler can...
Read more »

Posted in: ,
Pages 381234 »
Related Posts Plugin for WordPress, Blogger...
 
Design by Kholid Al Fakhry | Bloggerized by Lasantha - Premium Blogger Themes | Kholid Al Fakhry