I had to use something in a MySQL query last week that I haven't needed before. IGNORE INDEX I was aware that you could do this sort of thing, but I don't recall ever using it or seeing it in use before. I have a query that joins a couple tables and looks for records with a particular foreign key value. For some values of that column it was using an index that I added specifically for this query. This was taking 1-2 seconds to run. For other values it would use a different index and take 25-30 seconds to run. I added an IGNORE INDEX for the one that I didn't want. Then it started using a different index that had the same problem, so I had to ignore that one too. Now it seems to be working quickly for all values and using the index that I want. In most cases I have found that the database is pretty good and finding indexes that work best, but I guess not in this case.
Some Android applications use space on your Google Drive to store data. You can't see this data by browsing drive the normal way. You can get access to it if you get the access token from the app and do a few other things.
I use an app to keep some notes and other things. They require getting the paid version of the app to backup your data. I wanted to see if I could get it myself without paying for the app. I found out how to do this from this Stackoverflow post http://stackoverflow.com/questions/22832104/see-hidden-app-data-in-google-drive. The example there uses php. Since I have been learning Python recently, I decided to see if I could do the same thing with Python.
There is a pretty good explanation of why you need to go through all the steps you need to go through to get your data in the accepted answer for that post, so I won't go into too much detail about that here.
I use an app to keep some notes and other things. They require getting the paid version of the app to backup your data. I wanted to see if I could get it myself without paying for the app. I found out how to do this from this Stackoverflow post http://stackoverflow.com/questions/22832104/see-hidden-app-data-in-google-drive. The example there uses php. Since I have been learning Python recently, I decided to see if I could do the same thing with Python.
There is a pretty good explanation of why you need to go through all the steps you need to go through to get your data in the accepted answer for that post, so I won't go into too much detail about that here.
Comments
Post a Comment