08 February 2011

NEVER use Count with SQLite

Let be honest, Flex on Android isn't synonym with "Speed"
Even with a paged array (I won 10sec with it), I was fighting for 2hours with a 15 sec(!) delay before filling a list.

FYI, I'm using a 3000 rows table and id is a key...

If i use
(sql) SELECT COUNT(id) as count FROM mytable
and
(as3) return stmt.getResult().data[0]["count"];
this tooks 15 sec...

If I use
(sql) SELECT id FROM mytable
and
(as3) return stmt.getResult().data.lenght
this tooks 0.4 sec

so NEVER use COUNT!
Google it, you'll find COUNT isn't optimized at all on SQLite

05 February 2011

My games were stolen !

I today discovered a new kind of piracy...

1 month ago I published my (android) games on GetJar.
I planned to publish them on Android Market later (because of the fees).
It's just now impossible :
someone (Jasminstory or his clone integrixx) published my games (which he downloaded from GetJar) on the market, using the same name, the same screenshots, the same icons and even the same UIDs !

Yes, Jasminstory was able to publish air.com.willna.poulpytris from his own...
So, in the future, publish your game ANYWHERE you want to publish them at the SAME time...else someone could do it for you...

You could say "what's the matter? he paid the fees and publish it for you"...but
1/ he was SELLING my free games
2/ he was discovered and so I can't publish my games now, even if they were removed from the market
3/ the air.com.willna.xxx are now with a low profile on the market, few chances to be on the "Top" or "Try them" list now ....

I hope Google will help to solve this issue but it's now clear I won't earn a cent with these games...
so bad...
Nokia bullshit (more on this soon) and now that...
It's not my year, it seems...