| Abhijeet's profileAbhijeett's SpaceBlogListsNetwork |  Tools  Help |
Google SOAP Search API (beta)Google has created a SOAP Search Api Web service, which can be used by the developers for creating windows or web application to create a novel UI for searching or any other purpose, using any web service supported platforms such as Java,
Perl, or Visual Studio .NET. It uses SOAP and WSDL Standards of programming. The steps to implement is as follows: Step1: Download Developer's Kit The Developer's Kit can be downloaded from the following url. http://www.google.com/apis/download.html which contains .net and java samples and the wsdl file. Step2: Obtain License Key If you already have a gmail account just sigin and an email message containing the license key will be sent to you. https://www.google.com/accounts/Login? continue=http%3A%2F%2Fapi.google.com%2F createkey&followup=http%3A%2F%2Fapi.google.com%2Fcreatekey and if you doesn't have an account just go and create it. https://www.google.com/accounts/NewAccount? continue=http://api.google.com/createkey&followup=http://api.google.com/createkey Step2: Start Developing Applciation Once you get the License key, you can start developing the application using the API, but the program has to include the license key with each query you submit to the Google SOAP Search API service. Also there is a limit of 1000 queries per day, and its free beta service and is available for non-commercial use only. Talking about The .Brain Framework
Quote The .Brain Framework Reduce Network Traffic for MS SQLSet NoCount {ON|OFF} used to stop the messages indicating the number of rows affected by a Transact-SQL statement from being returned as part of the results. Normally any stored procedure that contains several statements which in actual does not return any data, in that case it is better practice to use the first statement as 'SET NOCOUNT ON' which will eliminate the sending of DONE_IN_PROC messages to the client for each statement in a stored procedure. This helps in greatly reducing the network traffic. Even though setting SET NOCOUNT is ON the @@RowCount function is updated. SQL Server Tips & Tricks
SELECT CustomerID, CustomerFirstName, City This technique results in reduced disk I/O and better performance.Use 'Derived tables' wherever possible, as they perform better. Consider the following query to find the second highest salary from the Employees table: SELECT MIN(Salary) FROM Employees WHERE EmpID IN ( SELECT TOP 2 EmpID FROM Employees ORDER BY Salary Desc ) The same query can be re-written using a derived table, as shown below, and it performs twice as fast as the above query: SELECT MIN(Salary) FROM ( SELECT TOP 2 Salary FROM Employees ORDER BY Salary DESC ) AS A This is just an example, and your results might differ in different scenarios depending on the database design, indexes, volume of data, etc. So, test all the possible ways a query could be written and go with the most efficient one. Use the more readable ANSI-Standard Join clauses instead of the old style joins. With ANSI joins, the WHERE clause is used only for filtering data. Where as with older style joins, the WHERE clause handles both the join condition and filtering data. The first of the following two queries shows the old style join, while the second one shows the new ANSI join syntax: SELECT a.au_id, t.title FROM titles t, authors a, titleauthor ta WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id AND t.title LIKE '%Computer%' SELECT a.au_id, t.title FROM authors a INNER JOIN titleauthor ta ON a.au_id = ta.au_id INNER JOIN titles t ON ta.title_id = t.title_id WHERE t.title LIKE '%Computer%' |
|
|
