Results 1 to 2 of 2

Thread: Bad queries

  1. #1
    Join Date
    Oct 2006
    Posts
    1

    Unanswered: Bad queries

    Can anyone recommend a method whereby malformed queries executed against a PSQL table without using an index can be prevented? Execution of these queries causes serious slow downs on our server.

    For example, a user writes a query without using an index. Or, uses a 'like %' in a query searching for text in a field without indexing.

    Tasering the users hasn't worked so I'd like to cut em off at the source.

    Matthew.

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    About the only way you're going to prevent users from writing malformed queries is to prevent them from running any query except approved queries.
    Now, if they are using the same query often and it doesn't have an index to use, I would suggest creating the index.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •