Thursday, December 26, 2013
Tuesday, December 24, 2013
Database query optimization for joins on large tables ( join two tables with 1 million rows each ) in MYSQL
Particularly for MY SQL join between two tables takes much time like 5 min in case of very large tables .
If your requirement is to show data on UI say in 5-20 sec max JOIN in query is useless .In that case we have implement join in memory using some caching techniques crudest may be use of soft cache .
If your requirement is to show data on UI say in 5-20 sec max JOIN in query is useless .In that case we have implement join in memory using some caching techniques crudest may be use of soft cache .
Thursday, August 15, 2013
Points while writing client Representational State Transfer (REST) ful web services
This blog confines only to consume RESTful web service and not writing web service itself .
Points -
Points -
- Basic framework available - Outh(only for web service authentication ) , Apache CXF etc.
- Sample Google API client using CXF , and Jasckson Json processor.
- General HTTP exceptions to handle
- Retry Logic in case of failure
Saturday, August 10, 2013
Share PC's dongle internet with iPad , Galaxy S4 phone
When my 3G plans for ipad and galaxy phone were used up I had big question how to share internet from PC to these gadgets . I used Connectify (costs 40 bucks $) , virtual router (it had already fucked up my time of 3-4 hours that shit never worked up ).I tried other things like from Antamedia virtual router but this costs so much and size was 66 MB .
This nagging question had eaten up my weekends and I was almost readied myself to throw 40 bucks down the toilet flush for Connectify .
But before that I visited Microsoft wifi support site and applied myself by going through all the details .
That thing was really a cinch , I don't know why moronic people are paying to Connectify while they have no that much extensive need to connect 100s of devices to shared hotspot .
For home use one can simply use shared internet connection .
Steps -
Share internet from dongle like Tata Docomo 3G etc to gadgets
1.Go to "Control Panel\Network and Internet\Network Connections"
2.Double click on internet modem
3.Click properties
4.Pop up opens
5.click on sharing Click on "Allow other network users to connect through .....internet connection "- you can check all check boxes
6. From drop down box select "Wireless Network Connection 2"
7. Click on OK . Some warning will come to restart connection etc .Click OK
8. Restart disable and enable dongle connection again
9. Check that "Wireless Network Connection 2" is in enabled state
Please cross check with screenshot
10.To create hosted wifi network for sharing internet
This nagging question had eaten up my weekends and I was almost readied myself to throw 40 bucks down the toilet flush for Connectify .
But before that I visited Microsoft wifi support site and applied myself by going through all the details .
That thing was really a cinch , I don't know why moronic people are paying to Connectify while they have no that much extensive need to connect 100s of devices to shared hotspot .
For home use one can simply use shared internet connection .
Steps -
Share internet from dongle like Tata Docomo 3G etc to gadgets
1.Go to "Control Panel\Network and Internet\Network Connections"
2.Double click on internet modem
3.Click properties
4.Pop up opens
5.click on sharing Click on "Allow other network users to connect through .....internet connection "- you can check all check boxes
6. From drop down box select "Wireless Network Connection 2"
7. Click on OK . Some warning will come to restart connection etc .Click OK
8. Restart disable and enable dongle connection again
9. Check that "Wireless Network Connection 2" is in enabled state
Please cross check with screenshot
using admin privileges
1. Start > All Programs > Accessories > Command Prompt. .
2. netsh wlan set hostednetwork mode=allow ssid=YourVirtualNetworkName key=YourNetworkPassword
To start
3.netsh wlan start hostednetwork
4. To see all
netsh wlan show hostednetwork
Enable your wifi and see that device is connected
11. For galaxy - Go to settings >> wireless and network >> wifi setting >> connect to your SSID wifi using password you are done - it will take time by showing obtaining IP etc but it will connect after 1/2 minutes
13. For ipad settings >>> wifi >> it will show your sahred wifi >> connect using SSID and password .Wait for 1/2 min till it shows it is connected and you see WIFI antena on right top on side of text "iPad" - Yes you are done at this point .
Enjoy internet !
NOTE : This can be used for home purpose only and not for hospitals, coffee shops etc public spaces where very large number are concurrent users access shared hotspot ! This is tested for windows 7 only !
There are many sites showing use of ad-hoc network set up but that shit never worked for me .
Please do not waste 40 bucks to Connectify or Antamedia while you can use inbuilt Windows 7 functionality
Subscribe to:
Posts (Atom)