Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 2 9
Impact
~22k people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
Apr
13
awarded  Popular Question
Mar
3
comment Can mariaDB contain indices only with data coming from remote tables?
ok. I got the point in terms of feasability. Now would it be technically possible?
Mar
2
comment Can mariaDB contain indices only with data coming from remote tables?
Hm. Data will be kept and maintained in the remote location, so I was thinking if it was possible to keep it there and still have "something" query-able like an index - says me, the "database-whitebelt"
Mar
2
asked Can mariaDB contain indices only with data coming from remote tables?
Sep
26
awarded  Famous Question
Jul
15
awarded  Notable Question
May
21
awarded  Popular Question
Feb
22
awarded  Notable Question
Nov
7
awarded  Popular Question
Sep
6
comment How to GROUP_CONCAT DISTINCT values in a MySQL query that gets number of records and min/max values?
Fixed it. See my answer. Thanks for helping out!
Sep
6
accepted How to GROUP_CONCAT DISTINCT values in a MySQL query that gets number of records and min/max values?
Sep
5
answered How to GROUP_CONCAT DISTINCT values in a MySQL query that gets number of records and min/max values?
Aug
30
comment How to GROUP_CONCAT DISTINCT values in a MySQL query that gets number of records and min/max values?
Thanks for the input so far. Good idea with length, but I tested running the query on a single article, which should only return: "s,m,l,xl" and I get "s,xl". So you are probably correct about the inherent error... :-)
Aug
30
asked How to GROUP_CONCAT DISTINCT values in a MySQL query that gets number of records and min/max values?
Jul
24
awarded  Commentator
Jul
24
comment Slow performance of MySQL Join Query
Thanks for the answer and help so far! I found the table had no index at all... I added one and went from scanning 60k+ rows to 23. I will post the show create sometime today.
Jul
11
comment Slow performance of MySQL Join Query
@ypercube: do you want to make "use EXPLAIN" an answer. First time I did, no index on the table, added an index. Down to a few milliseconds. THANKS
Jul
11
revised Slow performance of MySQL Join Query
added 539 characters in body
Jul
11
comment Slow performance of MySQL Join Query
can't get it to work from Coldfusion and since I'm working remote on the MySQL database I don't have edit privileges... any idea how to get the info, I'm looking for?
Jul
11
comment Slow performance of MySQL Join Query
where do I add this?