Tryangled Solutions web designing tips tricks

MySQL provides many extentions to SQL which help performance in many common use scenarios. Among these are INSERT … SELECT, INSERT … ON DUPLICATE KEY UPDATE, and REPLACE.

I rarely hesitate to use the above since they are so convenient and provide real performance benefits in many situations. MySQL has other keywords which are more dangerous, however, and should be used sparingly. These include INSERT DELAYED, which tells MySQL that it is not important to insert the data immediately (say, e.g., in a logging situation). The problem with this is that under high load situations the insert might be delayed indefinitely, causing the insert queue to baloon. You can also give MySQL index hints about which indices to use. MySQL gets it right most of the time and when it doesn’t it is usually because of a bad scheme or poorly written query.

Below is a list of keyboard shortcuts that can be used in Mozilla Firefox version 2.0 for Windows.

* CTRL+D: Add a bookmark.

* BACKSPACE: Move back.

* CTRL+B: Open Bookmarks in browser sidebar.

* CTRL+I: Open Bookmarks in browser sidebar.

* F7: Toggles Caret Browsing on/off.

* CTRL+W: Close current tab.

* CTRL+F4: Close current tab.

* ALT+F4: Close current window.

* CTRL+C: Copy.

* CTRL+X Cut.

* CTRL+MINUS: Decrease text size within web page.

* SHIFT+DEL: Delete an individual form.

* CTRL+J: Launch Download Manager.

* CTRL+G: Find again.

* SHIFT+F3: Find previous.

* F11: Put the current browser window in full screen mode.

* F1: Launch Firefox Help.

* CTRL+H: Display your browsing history.

* ALT+HOME: Load your home page.

* CTRL+PLUS: Increase text size within web page.

* F6: Move to next frame.

* SHIFT+F6: Move to previous frame.

* CTRL+T: Create a new tab.

* CTRL+TAB: Make the next tab active.

* CTRL+N: Open a new browser window.

* CTRL+O: Launch the Open File dialog.

* CTRL+ENTER: Open a link in a new tab.

* CTRL+U: Display the source of the current page.

* CTRL+V: Paste.

* CTRL+PAGE UP: Make the previous tab active.

* CTRL+P: Print.

* F5: Refresh the current page.

* CTRL+F5: Refresh the current page, overriding your cache.

* CTRL+S: Open Save Page As… dialog.

* ALT+ENTER: Open Save Link Target As… dialog.

* CTRL+A: Select all.

* CTRL+L: Select location bar.

* CTRL+DOWN ARROW: Select next respective search engine in search bar.

* CTRL+UP ARROW: Select previous respective search engine in search bar.

* CTRL+Z: Undo.

The steps in this tip will show you how to edit the registry for a time-saving shortcut for enabling and disabling your screensaver.
When you perform maintenance operations such as defragmenting or backing up the hard disk, you probably disable your screensaver before you begin to prevent it from interfering with the maintenance operation. However, disabling your screensaver manually is a multistep operation that involves accessing the Display Properties dialog box, navigating to the Screen Saver tab, and setting the screen saver to None. Then, you need to re-enable the screen saver after you complete the maintenance operation.
Fortunately, you can automate the disabling and enabling screen saver procedures with a couple of registry shortcuts. Note: Editing the registry is risky, so make sure you have a verified backup before making any changes.
Here’s how.

1. Launch Notepad and type the following four lines. (Note: The second line must be blank.)
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Control Panel\Desktop]
“ScreenSaveActive”=”0″
2. Save the file to your desktop with the name Disable Screen Saver.reg.
3. Change the 0 to a 1 in the fourth line.
4. Save the file to your desktop with the name Enable Screen Saver.reg.

Now, when you need to disable the screen saver, just double-click the Disable Screen Saver.reg shortcut. To enable the screen saver, double-click the Enable Screen Saver.reg shortcut.
When you run either of these files, the Registry Editor will display two confirmation prompts—one before making the change and one after making the change.

F1 / right arrow: Repeats the letters of the last command line, one by one.

F2: Displays a dialog asking user to “enter the char to copy up to” of the last command line

F3: Repeats the last command line

F4: Displays a dialog asking user to “enter the char to delete up to” of the last command line

F5: Goes back one command line

F6: Enters the traditional CTRL+Z (^z)

F7: Displays a menu with the command line history

F8: Cycles back through previous command lines (beginning with most recent)

F9: Displays a dialog asking user to enter a command number, where 0 is for first command line      entered.

Alt+Enter: toggle full Screen mode.

up/down: scroll thru/repeat previous entries

Esc: delete line

Note: The buffer allows a maximum of 50 command lines. After this number is reached, the first  line will be replaced in sequence.

Ctrl + Alt + End: Open the NT Security dialog.

Alt + PageUp: Switch between programs.

Alt + PageDown: Switch between programs in reverse.

Alt + Insert: Cycle through the programs in most recently used order.

Alt + Home: Display start menu.

Ctrl + Alt + Break: Switch the client computer between a window and a full screen.

Alt + Delete: Display the Windows menu.

Ctrl + Alt + NumpadMinus: Place a snapshot of the entire client window area on the Terminal       server clipboard and provide the same functionality as pressing Alt + PrintScreen on a local       computer.

Ctrl + Alt + NumpadPlus: Place a snapshot of the active window in the client on the Terminal       server clipboard and provide the same functionality as pressing PrintScreen on a local       computer.

Searching
“Ctrl+F” — Opens the Find dialog box.
“F3″ — Repeats the last search.

Browsing
“Keypad +” — Expands the selected branch.
“Keypad -” — Collapses the selected branch.
“Keypad *” — Expands all the selected branch’s sub keys.
“Up Arrow” — Selects the previous key.
“Down Arrow” — Selects the next key.
“Left Arrow” — Collapses the selected branch if it’s not collapsed; otherwise, selects the parent key.
“Right Arrow” — Expands the selected branch if it’s not already expanded; otherwise, selects the key’s first sub key.
“Home” — Selects My Computer.
“End” — Selects the last key that’s visible in the key pane.
“Page Up” — Moves up one page in the key pane.
“Page Down” — Moves down one page in the key pane.
“Tab” — Moves between the key and value panes.
“F6″ — Moves between the key and value panes.