609 reputation
11024
bio website
location
age
visits member for 2 years, 6 months
seen 2 days ago

May
8
comment Single query sending and retreiving duplicate data on MS SQL Server?
please check the programmers code.... the 70% of the speed it's up how developer create the query, probably they are doing some crazies queries that can be improve or check how it's the DB design(tables, relations, index, PK, FK). 25% it's up the DBMS, how the DB is configure, 15% it's the hardware (someone tell me if I'm wrong...)
May
8
comment USING construct in JOIN clause can introduce optimization barriers in certain cases?
It looks like "using" make the code a little bit readable but I guess that both fields need the same name. I don't think that using will have a better performance than a "on", because the DB need to make the match anyway, it's like a select have the same performance than a join (correct me if I'm wrong), the difference is that Join is cleaner and easier to maintain.
May
8
awarded  Teacher
May
8
revised What does COUNT(1) actually count?
added 17 characters in body
May
8
comment In MySQL, how to manually edit values of a BLOB column in few tuples?
I'm not sure 100% what you mean, but BLOB is used a lot to store files, like images. how to edit that? I think if you make a select of that field the only think that you'll see is BINARY code, so probably edit it wont be easy...
May
8
revised What does COUNT(1) actually count?
added 1098 characters in body
May
8
revised What does COUNT(1) actually count?
added 1144 characters in body
May
8
answered What does COUNT(1) actually count?
May
4
accepted Which is faster, InnoDB or MyISAM?
May
3
asked Which is faster, InnoDB or MyISAM?
May
3
accepted Which mysql storage engine to choose?
May
2
asked Which mysql storage engine to choose?
May
1
accepted what is bigger than a longblob?
May
1
comment what is bigger than a longblob?
I'm not trying to save anything, that question just came to my head. Lets pretend I want to put a bluray directly (around 20gb or more) into the DB
May
1
asked what is bigger than a longblob?
Apr
30
revised mysqladmin user account not secure?
deleted 13 characters in body
Apr
27
revised mysqladmin user account not secure?
added 2 characters in body
Apr
27
asked mysqladmin user account not secure?
Apr
26
accepted create more logs in Mysql, pros and cons?
Apr
26
accepted Difference between backup methods: Oracle and MySQL