Search Results

Search found 16 results on 1 pages for 'trojanwarrior3000'.

Page 1/1 | 1 

• difference betwen who and finger command in Unix/Linux?

  - by trojanwarrior3000

  Both commands look like have same purpose but their output is different. what is the difference?

  Read the article

• How to build a Terabyte queue ?

  - by trojanwarrior3000

  How to build/design/program a Terabyte or Petabyte queue in memory? (Imagine a twitter like service with huge number of users.)

  Read the article

• How to build a terra byte queue ?

  - by trojanwarrior3000

  How to build/design/program a terra byte or petabyte queue in memory? (Imagine a twitter like service with huge number of users.

  Read the article

• fast retrieval from MYSQL DB

  - by trojanwarrior3000

  I have a table of users - It contains around millions of rows (user-id is the primary key). I just want to retrieve user-id and their joining date. using "select user-id,joining date from table user" requires lot of time.Is there a fast way to query/retrieve the same data from this table?

  Read the article

• view and order by

  - by trojanwarrior3000

  why subquery of view can't have order by clause?

  Read the article

• what great software engineers know or aspiring ones should know?

  - by trojanwarrior3000

  I do not mean any particular language or methodology. But basics( one have abstracted from ones experience and interaction with smarter people in this field) one should have including concepts, practical issues, tips/techniques/tricks one should be aware of.For example the lessons or ideas may relate to programming,testing,design,project schedules, that are really useful in daily life of software engineer/developer etc ? This may be a good question because it looks not to specific, however experience of many is better than reading from books.I find discussions much helpful than books.Hope every one will have some lessons/ideas to contribute.please substantiate with atleast one example.

  Read the article

• Fast data retrieval in MySQL

  - by trojanwarrior3000

  I have a table of users - It contains around millions of rows (user-id is the primary key). I just want to retrieve user-id and their joining date. Using SELECT user-id, joining-date FROM users requires lot of time. Is there a fast way to query/retrieve the same data from this table?

  Read the article

• communication between 2 programs written in different language - Serialization ?

  - by trojanwarrior3000

  when is serialization,marshaling etc required during communication between programs residing across 2 different machines /network/Internet? Suppose I have a client program in java/flash and a server program in C. Can't I implement communication using a custom protocol of my own ? I guess so. When is serialization etc needed?I am aware Java RMI,CORBA etc have these mechanisms. But why? Is it a must? please enlighten me?

  Read the article

• (self,left outer,right outer,full outer) join - real world examples

  - by trojanwarrior3000

  can you tell me simple real-world examples for (self,left outer,right outer,full outer) join?

  Read the article

• correlated query /subquery VS join query

  - by trojanwarrior3000

  can we always convert a usual subquery/correlated subquery to join type query?

  Read the article

• index on index ?

  - by trojanwarrior3000

  can one create index on index ? why ? an example ?

  Read the article

• drop/truncate and rollback segment

  - by trojanwarrior3000

  I know that drop removes the data as well as the table structure whereas truncate retains table structure. Does drop/truncate write to roll back segment ?

  Read the article

• difference betwen who and finger command in Unix/Linux? [closed]

  - by trojanwarrior3000

  Both commands look like have same purpose but their output is different. what is the difference?

  Read the article

• Oracle transaction read-consistency ?

  - by trojanwarrior3000

  I have problem understanding read consistency in db(oracle). Suppose I am manger of a bank . A customer has got lock (which I dont know) and is doing some updation. Now after he has got lock I am viewing account info of the same customer and try to do some thing on it.But because of read consistency I will see data as it existed before customer got the lock. So will not that affect inputs I am getting and the decisions that I am gonna make during that period?

  Read the article

• read consistency in transaction Vs locks?

  - by trojanwarrior3000

  In oracle are these concepts- read consistency and locks related or independent ? why read consistency is needed? My assumption is that read consistency is achieved by locks.Is it ?

  Read the article

• ROWID (oracle) - any use for it ?

  - by trojanwarrior3000

  My understanding is that ROWID is a unique value for each row in the result returned by a query. why we need this ROWID ?( there is already ROWNUM is ORACLE). Have any one used ROWID in sql query?

  Read the article

1