The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
40 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 ...
0
votes
1answer
60 views

Can having a LIMIT on DELETE degrade performance dramatically?

I have a database project in php and mysql. For, hopefully redundant, data security I added a LIMIT 1 to the delete($uniqueID) php function we use. Nobody cared because records really aren't ...
0
votes
0answers
16 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 ...