yashsingh1/xdaforums huggingface dataset:
[Asus Transformer TF700] demandarin:
kind of like disk defragment for PC's?
[Asus Transformer TF700] d14b0ll0s:
Yes, this is a great analogy.
[Asus Transformer TF700] KilerG:
I used SQLite editor on my Bionic to change the value of the Verizon Mobile Hotspot "Entitlement Check" to "0" so I can use the hotspot app without paying for it ;)
[Asus Transformer TF700] d14b0ll0s:
:D ok, nice one! "hack the planet"! ;)

I meant managing the database itself, making it run smoother etc.
[Asus Transformer TF700] netzkind:
I am not entirely sure if i understand what you mean, but check out the VACUUM-Statement with sqlite (http://www.sqlite.org/lang_vacuum.html/).

Other than that, i can only see "removing old data from the database", but that would need a profound understanding of the structure and usage of each table for each application - so that's pretty much not possible.

If you have no idea what an SQL-Statement is or how to run it, you're better of leaving the databases alone ...

Furthermore, i assume that most apps don't store massive amounts* of data in sqlite and change it frequently, so a VACUUM might not solve anything.

* by massive i mean at least multiple thousands of rows in one table.

PS:

i take it that each application has at least it's own sqlite-database, or multiple, each of them in a separate file in the applications directory mostly. There is no "one central point" for that, it's nothing like server-based SQL (MySQL, MSSQL, Sybase ASE,...).
[Asus Transformer TF700] d14b0ll0s:
Thank you, this is exactly what I meant, I have no experience with SQLite whatsoever, this is great to learn that it is that different from SQL central databases management.

Do you think that the auto_vacuum mode is enabled for most databases nowadays by default or is there a reason to do the cleaning up manually?
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] hacknet07:
I've noticed a few issues with my device.

1. Overheating :eek:

-The device overheats when I surf the web (using 3G/4G antenna), run graphic intense applications, or play music for prolonged periods. Also, when I have the charger plugged while using it, the device becomes Extremely HOT.

2. Wi-Fi :confused:

-The WiFi connection keeps cutting off when I am well within my WiFi range. During the WiFi tests, I have the device sitting next to other smartphones and the GS3 drops the connection once or twice at least.

3. Battery :mad:

-I unplug the device from the charger at 8:00am (at 100% charge), and plug it back onto the charger again at 6:00pm (at 12-15% charge).

I am not a heavy user, but I do check Facebook, Emails, Google Chat, 1 or 2 YouTube (HD) videos, and 4-8 Text Messages per day.

I would consider myself to be between a light - moderate User.

Are you experiencing any of these issues as well?

(I sent an email to Samsung's Office of the President in New Jersey 2 days ago. Yesterday, I received a call from a very friendly and helpful gentleman from Samsung. Today I got a call from my wife, telling me that a brand new Samsung Galaxy S3 arrived to my door.)

If you need the email address for Samsung's Office of the President, please don't hesitate to ask. I will check back later. Thanks.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] bravomail:
Yes to battery and overheating. Try my ROM and turn on Power saving - both issues are gone.

WiFi helped by rebooting router.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] BonesHopkins:
I'm having similar issues. Strange battery life. Sometimes it seems ok but other times it drains like crazy for no good reason. Wifi sometimes goes into a disconnect/reconnect cycle.

And yes, I'd love to have that email address. Polite and well written emails to the right places can often work wonders. Thanks!
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] Razzman:
I too would love that contact information. I got mine just last week after using a Captivate for two years, Gets so hot at times i take it out of my pocket because it's uncomfortable! With a 2100 mAH battery I would have expected better battery life, which was part of the reason I got this device!
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] d1mitrov:
i would appreciate that email address. thx will be in order.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] Wickedone82:
if i could get that email as well i would be very grateful. my phone seems laggy at times and everytime i plug it into the charger about 5-10 mins later a message pops up saying charging paused phone battery temp to high and it drives me crazy because i have to leave my phone off the charger and im afraid that my phone might die and alarm wont go off in the morning .
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] hacknet07:
Samsung Office of the President Email Address

Hey Guys,

Word of advice before you send Samsung an email. Make sure you don't threaten or use profanity. I wrote a simple yet direct email requesting assistance. I myself would not respond to an email that includes threats or profanity... Good Luck !

president@sta.samsung.com
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] BonesHopkins:
hrmm....well, looks like you got better customer service than I did. I got an email back which basically said if it's broken I can either send it to them for an evaluation or if it's within the return period I can try to take it back. They didn't seem interested in my mentioning that the problems I'm having are being widely reported by a lot of people.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] hacknet07:
Samsung

Hey,

I'm sorry to hear that they handled your issue in that manner. I wonder if the rest of the members in here received the same result.

Did anyone else contact Samsung? Would you please post your results here. Thanks
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] BonesHopkins:
BTW, I did reply to them again and asked them to please look into it further. They reiterated what they told me earlier. Basically, it's not a known issue, they've forwarded the info I gave them to someone else but they can't say whether it will ever be fixed or even researched.

I had also asked them if they could provide me with a contact at ATT who deals with Samsung tech issues and they declined to provide me with any such info. They said if I wanted to I could contact my local service provider and if I was within my exchange period I should talk to them about exchanging the phone.

Basically, they don't seem to have a clue and didn't seem too interested in getting a clue. As someone who works in IT, I found this a little disappointing.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] hacknet07:
I'm assuming what is happening here is Samsung is pulling the Apple stunt with the (iPhone 4)antenna issue. They will try to deny it at first, then once it has become public, they will acknowledge that there is a known issue and will provide a solution. Hopefully, they don't provide us with fireproof gloves as a complimentary gift.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] BonesHopkins:
Yeah, I had hoped Samsung would be different than Apple but they're probably the same. If there's a problem, deny, deny, and deny until forced to admit it by firing squad. And then only admit it grudgingly and make up all sorts of excuses.

It's a nice phone but I guess Samsung as a company sucks just as bad as Apple and doesn't really give a flying frig about their customers or about acknowledging and resolving defects and problems as long as they are selling enough product to turn a profit.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] xtmoto:
OK this sucks.

Years ago, I got the Iphone 4 and you had to put a cover on it because of the antenna issue.

I get the S3 and to protect it, i get a cover and within no time, after putting it on the phone, the phone overheats, locks up, lags,

If i am charging it, it locks up. I was driving shortly after i put the case on, and it kept making noise but i was driving so i couldnt look at the phone. then once i got home. i noticed it locking up and really warm, bottom right hand corner.

This really sucks as i love the phone but I do know, overheating like this is not good for electronics and will lessen their lifespan.

anyone else having cover issues?
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] Sir Churchill:
Thinking about buying the SIII

Have you noticed differences between SII and SIII battert autonomy?

The SIII gives more performance but does the battery keeps its durability?

if you have had both phones, what differences have you noticed?

I want to compare the SIII with other phones but not benchmarks but user experiences
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] bslate07:
Mine gets a little warm when I'm using it with certain apps but never while it's in standby mode. I did also notice that the standby time seems to only drain the battery at about 1% per hour. Sometimes after I've been using it, the battery continues to drain like I'm using the phone when it's in standby. I'm anal about closing/killing apps when not in use too.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] taiwanese:
Got a reply within 20 mins:

Mr. XXX

We appreciate your patronage here at Samsung Telecommunications and we strive for the best in customer satisfaction. We understand that sometimes situations occur and we understand in certain circumstances are not convenient to customers. We apologize for any and all inconveniences that you have encountered. Please contact Samsung support for immediate resolution at 877-268-2121.

Thank you
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] tarheelsmj12001:
Im with Sprint but I am having the same issues as alot of people also. My phone overheats when charging and using and the WiFi signal is absolutely horrible unless I stand right next to the router.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] jev3gs:
Well it seems my heat issues are normal from what everyone is saying here. Would everyone say this is the hottest phone anyone as ever owned? The closest thing for me is an S2 and that got hit only while gaming. Surfing the Web was fine. This phone feels hot in 5 minutes of surfing on wifi. That just seems crazy.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] tarheelsmj12001:
Its not the hottest for me, my OG EVO 4G got alot hotter than my S3. But it does still get warm.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] jev3gs:
Really my cousin had that phone and he never complained about the heat. I guess I am just shocked that not one review on YouTube ever mentioned the heat.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] ventzi:
Same problem here. I'm on sprint S3 and just try to download a 50mb file and bottom half of the phone get very hot. Battery also start getting drained a little quick comparing to a regular use. Yesterday I was in my car and use navigation and stream a Google music to my car stereo over BT and when I get home the phone the get extremely hot and it was almost untouchable. This happen on naked phone. I did order a Seidio Surface case and I'm pretty sure that the phone will probably start lacking because of the overheat when I put the case on.

I'm still in 14 days from my purchase but I'm not sure what to do. If I return it and get another one it will be the same right?

Is your new phone (that they send you) acting the same or the issues get resolved?

thanks
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] skalatsky:
I had the Wi-Fi issue of getting disconnected all the time but then I exchanged phones and the problem has decreased.

As for the heat it is bearable and I believe my old galaxy s2 got way hotter and same goes for my old galaxy s1.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] yellowfddriver:
@OP:

What sort of things did you include in your e-mail?

I was thinking of sending an e-mail, if for nothing, to show that this is an issue. Maybe it's only an ATT related issue. I doubt I'd be sent a new phone (seems like you got lucky in this circumstance), I'm going to return this phone today after I return from work...I was so excited to pick mine up from my local ATT store, but the heating issue, the visual lag were extremely disappointing. Even the att logo on the boot screen lagged! The HOX (excessivly tampered with pre-root by ATT :( ) didn't even have that sort of lag.

As one of the "horses" in the Apple/Samsung mobile phone duopoly, I expected better :(
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] hacknet07:
I would suggest going to the store where you bought it from and replacing it a few days before your 30 day return policy is over.

The replacement device which I received from Samsung, did not resolve my issues. It was worse than the one I had. It kept freezing while I was setting up the device for the first time. I reset the device and tried again and I received the same results(lag, freezing, heat). I put a return label on the box and sent it back to them the same day.

Hopefully, Samsung acknowledges the issue and applies a fix to the next batch before sending it out. I highly doubt it, but I like their products so I have faith.

I am going to wait until the last day of my 30 day return policy with At&t, then I'll go back and swap it out for another (hoping that it came out of the good batch).
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] hacknet07:
- How to fix the WiFi -

WiFi issue resolved

Unlock your Galaxy S3 and go to:

1. Settings

2. About Device

3. Software Update

This update will resolve your WiFi issues, but it will kill the Universal Search feature on your device. Apple sued and so Android was forced to remove the feature.

APPLE :mad:

If you would rather do it manually without killing your Universal Search feature, follow the directions below:

Open the Phone Dialer and press *#0011#. This opens the “ServiceMode” screen.

From here, tap the Menu button (capacitive), and select WiFi.

Once in the WiFi page, press the ON button to switch it to OFF(you might have to scroll down a bit to see the button).

Hit the back button twice to exit the screen.

That should resolve the WiFi issue.

(It has been reported that the manual fix causes the battery to drain faster)

Good Luck!
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] hacknet07:
Did you replace the device? Did the replacement resolve your issues?
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] hacknet07:
Did you swap it for another device? if so, how is the new one working out for you?
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] Optimizer:
I am working very hard and going through MANY logcats gathered by people and sent to me to work on a WIFI disconnect/reconnect fix. I think I have it down on why this is happening, but I want to be sure. I will be posting a flashable zip if I can find the fix.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] ventzi:
.

Thanks for that reply. Maybe I will do that but meanwhile I did all these steps and so far my phone getting better. Overheating is almost gone and battery life is getting mush better.

These are the steps that I did and seems to help me to reduce this process (Android system) to like 5 %. I'm on Sprint S3 but should be the same for the all carriers.

Go ahead and open Talk application. You should see your account in green (I'm not using this application) then hit the menu and then select sigh Off. Make sure that your account changes to Offline (sometimes it is change back it self so open one more time make sure that it says Offline). Then what else I change is in wi-fi advanced options: under Keep Wi-Fi on during sleep I choose Only when plugged in option. then I reboot the phone and from now on (almost 2 days) my Android system process show up only 5% of usage and my battery life improve significantly. I hope this will helps.

Thanks

I will continue monitoring and testing.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] tehsprayer:
Overheating I think is normal because after you use the phone especially for YouTube videos the phone will get hot. Also, this phone should last about 3 hours of screen time and I'm guessing not much more than an hour of watching HD YouTube.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] taiwanese:
Just got an email from office of president in the states indicating that a new phone is on it's way.........Not sure if it will be any better.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] hacknet07:
Were you able to find anything?
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] hacknet07:
Awesome! Please let us know what happens. I am curious to see if they have addressed the issues. Thanks.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] taiwanese:
Will do

Not sure if it will fix anything
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] Alex2x3:
Do they ask you to send your old phone back? haha
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] hacknet07:
Unfortunately, yes. They will put a return sticker in the box. :D

-----------------------------

SGH-i747
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] Sp33Demon:
I got my Galaxy S3 three weeks ago and like other have mentioned in this thread, I was seeing ridiculous battery consumption (8 hours under light use, less using it the way I wanted to) and the lower half of the phone would get hot doing anything for more than ten minutes. I was not happy at all but instead of running back to the store, I decided I had time to see if it was something I or AT&T did.

1. Rooted my phone and installed Titanium Backup.

2. Froze all AT&T and Samsung bloatware and apps I use sparingly.

3. Ixnay on the live wallpaper I was running.

4. Uninstalled software that was running in the background that I really had no need to be running in the background.

5. Upped on mail (regular and Exchange) and other refreshed data to 15 minute intervals.

I keep WiFi and LTE on full time. All power saving features are on and screen at 50%.

Those five simple steps made all the difference in the world. I can easily go an entire day without crazy drain (even playing games for 20 minutes does not drain terribly and it does not get hot...still can get a little warm).

There is still some high drain for about 20 minutes when I wake up in the morning and take it off the charger where it drops from 100-97% (still don't know what that is) but it settles in and over the next 2-3 hours it will settle and stay in the 92-95% range. By 5pm and after calls, mail checking, some gaming or surfing while waiting for kids, I'm still in the 60-80% range. Before, I would be in the 30-50% range.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] JB calhoun:
Tock rooted ocd is awesome for me

sent from my red ass oc'd s3
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] hacknet07:
Awesome! I appreciate all the participants. Without participation, these issues will never get resolved.

-----------------------------

SGH-i747
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] iiApotheosis:
Here is one way to stop the wifi from turning off and on. Go to the dialer dial *#0011#* press menu select wifi from the list. And flip the switch below "wifi power save mode" to off. Apologies if someone already posted this I'm on the latest leak and it still happens to me with the stock kernel I remember seeing someone posted that somewhere and just remembered it and did it.

Edit: just saw that someone did in fact post this on the previous page. OP should post it to the original post.

Sent from my Garnet Red Samsung Galaxy S3.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] shalom azar:
i have some issues

i have the overheating issue but i dont have any other issues... ive heard about the wifi issue but it never affected me... and for battery life i actually get great battery life so i have no complaints of that
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] lord_czar:
I have the same issue, and it happen to me when I'm using whatsapp or browsing the internet, my phone gets hot at the second minute of browsing and the battery begins draining very fast (about 5-10% per 10 mins of internet browsing).

The drop 100-97% of your phone is related of how you charge your phone. Accordingly to batteryUniversity, the best way to charge your phone is to turn it off while charging, because it will give you the right % of charge, because when it's on, some of the charge is to mantain the actual functionality of the pone (wifi, radio, background processes, etc..) and the charger gets confused when it reachs the "ready" signal.

You can try leaving the charge plugged for 20 min more after the led goes green.

Hope it helps.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] RiPpeR_dUdE:
Since most probably charge the phone while its on, once fully charged, if you unplug, then re-plug immediately back in, after a few minutes will indicate a full charge again; in most cases, this also resolves the false percentage.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] twanskys204:
Can I have the email address
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] hacknet07:
It's on the first page i think. I posted it already. Thanks

-----------------------------

SGH-i747
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] perry_henis:
I just phoned Samsung here in Canada and they gave me a UPS label to print out and send back for service.

They asked for the S/N and model, that was it. Painless. 2-5 weeks with a secondary phone and the problem should be solved. I'll keep the thread posted.
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] hacknet07:
Great thanks!

-----------------------------

SGH-i747
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] tehsprayer:
same happens to me. Biking to keep posted on this topic as people are getting sent for warranty and would like to know this outcome
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] twanskys204:
Ahhh just bought note 2 screw it:D

Sent from my SGH-I317M
[AT&T, Rogers, Bell, Telus Samsung Galaxy S III] sly-tendencies:
Unless I browse heavy on LTE, battery life on stock is usually in the 12-14 hour range, which is more than satisfactory to me. Don't have a problem with wifi connectivity but the phone gets really hot. Probably the one major drawback for me.

Stock ICS on my S3 :(
[AT&T Samsung Galaxy S II Skyrocket SGH-I727] droidfoshizzle:
does anyone have a copy of our LF5 base framework with CRT Off activated? or better yet, a CWM zip file for ICS

I;ve tried searching but could only find gingerbread
[AT&T Samsung Galaxy S II Skyrocket SGH-I727] StolenVW:
I just did that and aosp lock screen on the stock ics
[T-Mobile, Samsung Galaxy SIII] sambo234:
Mildly regretting buying my phone at launch now...

http://www.latimes.com/business/tec...le-galaxy-s-iii-sale-20120711,0,6467228.story
[T-Mobile, Samsung Galaxy SIII] ayeitschris:
alright, i just talked to a tmobile rep online, and they said you need to add a new line to get the free phone..

or the rep could have been wrong.

but heres what it said on the bogo page.
[T-Mobile, Samsung Galaxy SIII] sambo234:
I called in a little bit ago to see if I could have it retroactively applied (3 weeks ago) to no avail, but was told that it applies to upgrades on existing lines as well.
[T-Mobile, Samsung Galaxy SIII] falcons2:
How long will they be running this promo??
[T-Mobile, Samsung Galaxy SIII] ayeitschris:
Wait, so does that mean you could get the second phone free as an upgrade on another line?
[T-Mobile, Samsung Galaxy SIII] dasistsparta:
What if you add a line then pay early termination fee $200 then you still get to keep both phones?
[T-Mobile, Samsung Galaxy SIII] jgalan14:
Aperrently yes good chance to get someone in your line lol
[T-Mobile, Samsung Galaxy SIII] itsjusttim:
I just called Tmobile and the lady kept telling me the s3 isn't eligible for the bogo. Dumb girl has no idea.. Tmobile customer service is awful compared to what it used to be.

Edit: I called back and the s3 is not only available, this girl allowed me to apply it to the order I made last Saturday. This girl was amazing.
[T-Mobile, Samsung Galaxy SIII] lkctd8:
The s3 is allowed as the first phone but not as the free phone.... At least at a store level. If they are doing a mail in rebate for you good luck, but if they let you do it instantly you lucked out!