Announcement

Collapse
No announcement yet.

Slow Query

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Slow Query

    We have a UK PAF Address Database 28.5 Million records

    The initial page is search with only one search field enabled. (Which loads instantly)

    When searching it takes approx 2 minutes.

    The search field in question is indexed in the mysql database.

    when running the sql query manually in workbench the results are instant.

    Does scriptcase cache the database prior to the query ? if so can it be turned off ?

    Any Ideas would be appreciated.

    Many Thanks

    Chris

  • #2
    Originally posted by christwigg1974 View Post
    We have a UK PAF Address Database 28.5 Million records

    The initial page is search with only one search field enabled. (Which loads instantly)

    When searching it takes approx 2 minutes.

    The search field in question is indexed in the mysql database.

    when running the sql query manually in workbench the results are instant.

    Does scriptcase cache the database prior to the query ? if so can it be turned off ?

    Any Ideas would be appreciated.

    Many Thanks

    Chris
    IF you are using a grid then the html will contain all the records, afaik there's no lazy load. So if the result set is large it could take a while to load. to see if it's a database issue you can turn on the debug option to show the query. Then you can use phpMyAdmin to see if the query is taking the time, if the right search path is used etc. Then you can point down the problem and then see what needs to be done to solve it.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      I haved a similar case. My problem was with field type text in Search.
      My solution was in: SEARCH - Field Behavior - Use autocomplet = NO.

      I think SC seach records for this type of fields and if the DB is Big then is slow.

      Comment

      Working...
      X