ST Alpha - "eh ... the number of replies is calculated dynamically, so the subqueries for that would cripple the database -- nm" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 155

In response to "Bery, have I suggested this before? A checkbox on the search page for "only posts with 5 or more replies"" by Dr.Vermin

eh ... the number of replies is calculated dynamically, so the subqueries for that would cripple the database -- nm

Posted by Beryllium (aka grayman) Jul 20 '12, 13:39

(No message)

Responses:

Can't you set it up as an outer query? - GregW Jul 20, 13:43 5
- go back to your DB2 world - zork Jul 20, 13:48 3
  - Gladly. My company just bought another company that has a MySQL database. Fortunately, my work is just converting it. -- nm - GregW Jul 20, 13:53 2
    - we use MS here -- nm - zork Jul 20, 13:56 1
      - although most of my work is non-db but crunching fixed column or card format flat ascii files. -- nm - zork Jul 20, 14:01
- replies are recursive. MySQL is not ... friendly ... to recursion or nested sets. -- nm - Beryllium Jul 20, 13:45
FIX IT! -- nm - Max Jul 20, 13:40 5
- Max! -- nm - Beryllium Jul 20, 13:40 4
  - Speaking of, did you change something today? Links are opening in the same tab rather than a new one. - spamlet Jul 20, 14:03 3
    - didnt you just answer your own question? -- nm - tRuMaN Jul 20, 14:09
    - Possibly the IM -- nm - Beryllium Jul 20, 14:04 1
      - Okay. Who knows. Probably some magic keypress. Thanks. -- nm - spamlet Jul 20, 14:13

Post a message top

Replies are disabled on threads older than 7 days.