No announcement yet.

Problem workaround and question

  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem workaround and question

    I was trying to debug why often in SC development environment goes into error by selecting an object from the tree (eg a field)
    and I discovered something very interesting (!)

    Whenever SC executes a sql statement to collect information on the object from the database,
    always performs a SELECT TOP 1 * FROM "view_name" WHERE 1 = 0 statement
    "view_name" is the name of the first view of the database in alphabetical order.

    Not wanting to talk about the strange reasons why this statement is executed so often, I found that
    if the view in question is "heavy to carry" the system often stay a lot of time in wait and
    after that has an error at line 845 of / prod / third / adodb / driver / adodb-mssql. inc.php

    I created now a simple view named "aaa" on database and the problem has magically solved .... and the IDE is also much faster !!!

    Now the inexplicable statement is still performed but the time wasted is smaller.

    I'm using SC 8.1.041 on Ubuntu Linux and the database is SQL Server 2008 r2 thru Freetds.

    The question is... why this statement? Slow down the development time and for sure there is another way to chech if there are views or tables in database.
    Giorgio Bravi
    Dolphin Software & Thinkware