Skip to main content

Home/ Groups/ ProgrammingPages
Navneet Kumar

Javascript - Introduction to Events - 0 views

  •  
    event handling in javascript
Navneet Kumar

The Spring Framework - Reference Documentation - 0 views

  •  
    The Spring Framework - Reference Documentation
Navneet Kumar

MySQL Performance Blog » What to tune in MySQL Server after installation - 0 views

  •  
    tuning mysql server for perfornmance
Navneet Kumar

MySQL Reference Manual for version 5.0.3-alpha - 23 Error Handling in MySQL - 0 views

  •  
    mysql error codes
Navneet Kumar

SQL Server 7.0: Resolving System Error Messages - 0 views

  •  
    some ms-sql error-code  descriptions
Thiyagarajan Sadasivam

Essential Vim - 0 views

  •  
    Essential keyboard shortcuts and commands for VIM
Navneet Kumar

JavaScript tutorial - 0 views

  • for your own objects, you may wish to provide a special string that may provide more useful information. To do this, simply define the 'toString' method:
  • not have to store individual copies of the methods for each instance of the object, so it may require less memory, but it will require the browser to search the current and parent scopes to find the methods. This may cause a marginal delay
  • Saying 'this.propertyname' as I did above will create a public property. Any script can create an object then use and modify its properties directly. Using 'var' to define a variable in the constructor will create a private property.
  • ...7 more annotations...
  • Private variables can only be accessed from methods that are declared inline, and not externally referenced or created using the prototype construct. Methods of this kind are also known as privileged methods
  • prototype chain.
  • That also means that if the mycircle prototype is changed (properties are added or deleted, etc.), these changes are replicated down the chain, so the mysphere also inherits these changes.
  • mysphere.prototype.constructor = mysphere;
  • I will take all of the methods out of the constructor, and add them later using the prototype. That way, the mycircle prototype methods will always be available without me needing to create a new mycircle. Unfortunately, this also means that public and private properties are very hard (or impossible) to use. It's a trade off - one functionality for another.
  • When running the method, we need to tell JavaScript that even though we are referencing a method for a different prototype, we want to run it as if it were a method of the object we are creating (to make sure that any properties it creates are added to the object we are creating). This could be done using the 'call' method or 'apply' method
  • Note that when assigning the mycircle object to the mysphere prototype, it also overwrites the mysphere prototype constructor property
  •  
    complete Javascript tutorial
Navneet Kumar

MySQL Performance Blog » MySQL Query Cache - 0 views

  • It does not cache the plan but full result sets
  • so it looks at first letter of the query and if it is “S” it proceeds with query lookup in cache if not - skips it.
  • Might not work with transactions
  • ...15 more annotations...
  • uses non-deterministic functions such as UUID(), RAND(), CONNECTION_ID() etc it will not be cached.
  • If table gets modification all queries derived from this table are invalidated at once
  • if you have high write application such as forums, query cache efficiency might be pretty low due to this.
  • all queries are removed from cache on table modifications - if there are a lot of queries being cached this might reduce update speed a bit
  • Qcache_free_memory and Qcache_lowmem_prunes
  • number of your selects - Com_select and see how many of them are cached. Query Cache efficiency would be Qcache_hits/(Com_select+Qcache_hits).
  • One portion of query cache overhead is of course inserts so you can see how much of inserted queries are used: Qcache_hits/Qcache_inserts Other portion of overhead comes from modification statements which you can calculate by (Com_insert+Com_delete+Com_update+Com_replace)/Qcache_hits
  • want to set query cache
  • means it is much more efficient as query which required processing millions of rows now can be instantly summoned from query cache
  • It also means query has to be exactly the same and deterministic, so hit rate would generally be less
  • full page caching
  • not using query_cache_wlock_invalidate=ON locking table for write would not invalidate query cache so you can get results evenif table is locked and is being prepared to be updated
  • it can serve responses very fast doing no extra conversion or processing.
  • but it is still not as fast as specially designed systems such as memcached or local shared memory.
  • It is not distributed If you have 10 slaves and use query cache on all of them cache content will likely be the same, so you have multiple copies of the same data in cache effectively wasting memory
  •  
    mysql query caching
Navneet Kumar

mysql query cache - 0 views

  •  
    tuning mysql performance with query caching
Navneet Kumar

Pythian Group Blog » MySQL: Tuning filesorts and temporary tables - 0 views

  •  
    filesort and temporary tables in query
Navneet Kumar

SQL Server Data Structure - 0 views

  •  
    MS SQL Server Data structures. how data is stored in ms sql  server
Navneet Kumar

Vi for programmers - Program - UNIX - Builder AU - 0 views

  •  
    taming vim, vim options
Navneet Kumar

MySQL AB :: MySQL 5.0 Reference Manual :: 13 Storage Engines - 0 views

  •  
    mysql storage engines myisam and innodb
Navneet Kumar

Generics in C#, Java, and C++ - 1 views

  • And really all they're doing in their implementation is automatically inserting those type casts for you. So you get the syntactic sugar, or some of it at least, but you don't get any of the execution efficiency
  • because Java's generics implementation relies on erasure of the type parameter, when you get to runtime, you don't actually have a faithful representation of what you had at compile time. When you apply reflection to a generic List in Java, you can't tell what the List is a List of.
  • C# does the instantiation at runtime.
Navneet Kumar

Unusual software bug - Wikipedia, the free encyclopedia - 0 views

  •  
    heisenbug, bohrbug, mandelbug, schroedinbug
Navneet Kumar

PatHelland's WebLog : Normalization Is for Sissies - 0 views

  •  
    de-normalization is ok if you are not going to update
Navneet Kumar

When Not to Normalize your SQL Database - SWiK - 0 views

  • With the above design, it takes six SQL Join operations to access and display the information about a single user. This makes rendering the profile page a fairly database intensive operation which is compounded by the fact that profile pages are the most popular pages on social networking sites.
  • Database denormalization is the kind of performance optimization that should be carried out as a last resort after trying things like creating database indexes, using SQL views and implementing application specific in-memory caching. However if you hit massive scale and are dealing with millions of queries a day across hundreds of millions to billions of records or have decided to go with database partitioning/sharding then you will likely end up resorting to denormalization
    • Navneet Kumar
       
      De-Normalization is OK if you are'nt going to update
  • Denormalization means that you you are now likely to deal with data inconsistencies because you are storing redundant copies of data and may not be able to update all copies of a column value simultaneously  when it is changed for a variety of reasons. Having tools in your infrastructure to support fixing up data of this sort then become very important.
  •  
    De-normalizing database to improve speed.
Navneet Kumar

What about Sun embracing JavaScript? - 0 views

  • There's a lot of work being done by the Mozilla foundation and Adobe to integrate a killer JavaScript interpreter into both Flash and Firefox using Adobe's Tamarin engine
Navneet Kumar

SQL Server 7.0: System Error Messages - 0 views

  •  
    All ms-sql system error messages
Navneet Kumar

perlintro - perldoc.perl.org - 0 views

  •  
    perl intro tutorial     
‹ Previous 21 - 40 Next › Last »
Showing 20 items per page