meta user
network profile
| bio | website | in.another.dimension |
|---|---|---|
| location | Athens, Greece | |
| age | 45 | |
| visits | member for | 2 years, 3 months |
| seen | 3 hours ago | |
| stats | profile views | 528 |
Interests: math, programming and games, not necessarily in that order.
Not sure if my next web app will make me a millionaire or a billionaire. In the mean time, I'm looking for a new job. Send proposals to my personal email: ypercube@gmail.com
|
5h |
comment |
How can I include more query in one query? And the GROUP BY id is probably a typo? I don't see an id column anywhere. |
|
6h |
comment |
How can I include more query in one query? Try USING (qid) instead of USING (tbl_answers.qid) |
|
7h |
reviewed | No Action Needed Would Mongo's ObjectID work well in InnoDB's clustered index? |
|
7h |
reviewed | Approve suggested edit on Migration of create statement from SQL Server to MySQL |
|
7h |
revised |
Why are constraints applied in the database rather than the code? rolled back to a previous revision |
|
1d |
comment |
Is there any way to prevent the memo structure from being pruned? And why should it do that? If it has calculated say a plan with cost=7, and then finds that any plan that includes a hash join b will cost 10 or more, why calculate all those million plans and not prune them? (not that the optimizer works in such a simplistic way) |
|
1d |
comment |
Is there any way to prevent the memo structure from being pruned? It's not clear what you want to prevent. Do you want to somehow force the optimizer to calculate a cost for all possible plans (which can be on trillions of zillions, even for a simple query with 10 joins)? |
|
1d |
comment |
Looking for performance improvements for this query And why the 2nd table doesn't have a primary key? |
|
1d |
comment |
Looking for performance improvements for this query This is going to need some complex indexes but why haven't you at least added an index on studentMLs (quizid) that you use for joining? And shouldn't there be a FOREIGN KEY constraint on that column, to reference quizzes (idnum)? |
|
1d |
comment |
Looking for performance improvements for this query Is IFNULL(Q.book,0) = 0 more efficient than (Q.book IS NULL OR Q.book=0)? Oh sorry, your idea is to limit first to 100 rows, so this won't matter much. |
|
1d |
reviewed | Leave Open How to restore IBM DB2 database from AIX to Windows? |
|
1d |
reviewed | Close How to fix error: Connection is busy with results for another hstmt (SQL-HY000) |
|
1d |
comment |
Second time query execution using different constants makes faster? What indexes do you have on the table? Either a (status, idvendor, chargetype, addeddate) or (status, idvendor, addeddate, chargetype) index would be quite efficient. |
|
1d |
reviewed | No Action Needed Backup very large table |
|
1d |
reviewed | No Action Needed SQL Server 2008 R2 corrupted after changing MAXDOP |
|
1d |
reviewed | Close Connecting To Oracle with D2K & PHP |
|
1d |
comment |
Query optimization when no row is returned @RolandoMySQLDBA thnx |
|
1d |
answered | Query optimization when no row is returned |
|
1d |
awarded | Constituent |
|
2d |
revised |
Is there any way to trace optimizer's work in MySQL? added 130 characters in body |
