meta user
network profile
| bio | website | phpfreaks.com |
|---|---|---|
| location | United States (but travelling) | |
| age | 33 | |
| visits | member for | 1 year, 7 months |
| seen | yesterday | |
| stats | profile views | 31 |
I am not a handy programmer but I play with php with a hope to develop creative ideas.
|
Aug 24 |
asked | How to make multiple counts in one query? |
|
Jul 11 |
awarded | Popular Question |
|
Jul 3 |
accepted | Trigger to UPDATE after UPDATE? |
|
Jul 3 |
comment |
Trigger to UPDATE after UPDATE? What is the benefit of BEFORE over AFTER (not in this case), because you said you usually use BEFORE? and what do you mean by setting the updated column as NEW.updated? |
|
Jul 3 |
asked | Trigger to UPDATE after UPDATE? |
|
Jun 8 |
awarded | Constituent |
|
Jun 8 |
awarded | Caucus |
|
May 17 |
comment |
How to order query results by tag weight in IN('tag1', 'tag2', 'tag3') how it can be beneficial? indexes are always good for speed. |
|
May 17 |
comment |
How to order query results by tag weight in IN('tag1', 'tag2', 'tag3') Thanks for your consideration, but it will not be practical as sub-SELECT is slow. |
|
May 14 |
comment |
How to order query results by tag weight in IN('tag1', 'tag2', 'tag3') @Jannes it will not ORDER by PRIMARY KEY, but the results will be retrieved in this order (i.e. order of INSERT). At least in my experience (maybe by chance ;) |
|
May 13 |
comment |
How to order query results by tag weight in IN('tag1', 'tag2', 'tag3') @Phil yes, I added description to clarify the issue. |
|
May 13 |
revised |
How to order query results by tag weight in IN('tag1', 'tag2', 'tag3') added 79 characters in body |
|
May 13 |
asked | How to order query results by tag weight in IN('tag1', 'tag2', 'tag3') |
|
Apr 23 |
accepted | Is it normal to use many Triggers? |
|
Apr 23 |
accepted | Why using innodb_file_per_table? |
|
Apr 8 |
asked | Why using innodb_file_per_table? |
|
Apr 6 |
comment |
Is it normal to use many Triggers? very interesting play with Blackhole engine! I've never thought of this Master/Slave combination. |
|
Apr 6 |
comment |
Is it normal to use many Triggers? I've batch process strategy for another case, but here it is not good at all. Consider 10 users have posted in the past 24 hours. I need to perform COUNT for total users (say 1000) to update summary column for 10 user activity. |
|
Apr 6 |
comment |
Is it normal to use many Triggers? Thanks for explicit answer. (a) they will be displayed as statistics, e.g. for a user profile (regularly then); (b) this varies from case to case: consider many votes (very often), and posting comment (not many times). (c) Do you mean to keep all columns which will be updated in ONE table? You try to keep the database far from messy action, by limiting trigger actions to one single table only? |
|
Apr 6 |
revised |
Is it normal to use many Triggers? edited title |
