228 reputation
211
bio website
location Cluj-Napoca, Romania
age
visits member for 2 years, 7 months
seen Oct 18 at 12:19

I work as a PHP developer at Pentalog where we develop the largest dating site in Europe.

I thrive in challenging environments and am never afraid to get my hands dirty.

My passions include computer programming, psychology and poker.


Dec
15
awarded  Notable Question
Sep
24
awarded  Autobiographer
Sep
8
comment INSERT takes over 5 hours, when inserting more than specific number of rows
Do the logs say anything ?
Sep
2
awarded  Nice Question
Jun
4
awarded  Yearling
Dec
3
comment Change MySQL 4.1 Windows to MySQL 4.1 Linux- Problem with the key Sensitive in query
OMG it's 2004. I should buy some Apple shares.
Sep
6
comment How to update a table from a another table
Sorry, I guess I was too pissed off to realize I was out of line. I'll delete it.
Jun
13
awarded  Popular Question
May
21
awarded  Caucus
Feb
20
awarded  Commentator
Feb
20
comment Mysql: disable unused schemas
Actually, if you have many databases, starting MySQL will not automatically put them in RAM... unless you explicitly set something like that up... which clearly you didn't... Have a look at MySQL configuration, maybe the cache sizes for InnoDB are too high or... something similar
Jul
25
awarded  Teacher
Jul
25
comment Why is DELETE so much slower than SELECT, then DELETE by id?
@itsadok I wrote it as an answer :) .
Jul
25
answered Why is DELETE so much slower than SELECT, then DELETE by id?
Jul
25
comment Why is DELETE so much slower than SELECT, then DELETE by id?
@pconcepcion if you write EXPLAIN DELETE FROM...., it won't work. From what I know, it works only on SELECTs.
Jul
25
comment Why is DELETE so much slower than SELECT, then DELETE by id?
Yeah but.... you were right in the first place. If the field email is unindexed, then both DELETE and SELECT should work equally slow. Or: You say that the table is queried heavily. Maybe when you tried your first DELETE there was someone else running a really long transaction on those rows...
Jul
25
comment Why is DELETE so much slower than SELECT, then DELETE by id?
I guess you absolutely must post a SHOW CREATE TABLE and probably an EXPLAIN... too.
Jul
23
awarded  Citizen Patrol
Jul
23
awarded  Critic
May
17
awarded  Scholar