The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
2answers
42 views

Which query performs better when searching a row where a column has maximum?

Consider a simple table for example purposes: person(name varchar, age int) I have a task to retrieve the oldest person. Which query is better in general for such problems? Query 1: criteria with ...
1
vote
1answer
28 views

MySql LIMIT + JOIN is stopping data from being returned?

I originally posted this question on stackoverflow, but then remembered there's a stackexchange specifically for databases! I've got two tables and am trying to return all profiles that are assigned ...
0
votes
1answer
51 views

Does LIMIT 1 still have effect on a unique column

I know that adding LIMIT 1 when searching for only one record makes a lot of difference when it comes to performance. But does it still have any effect when we search a column with a unique ...
0
votes
0answers
16 views

MySQL failed connection attempts hitting max_connections

I run a couple of websites but I believe one of them is causing too many Connections Failed Attempts that causes max_connections variable to hit. Currently, max_connections=2500 (already large) but ...
0
votes
0answers
30 views

LibreOffice Base randomly changes character limit in forms

I have to work with LibreOffice Base, and when I created a form to fill the table. It worked perfectly, but when I wanted to use agains it randomly changed the maximum type-able character limit. I ...