S
Samuel
Hello,
First, I have an application which display in a grid data from a table in a
SQL server. When the table is modifie, a notification is sent by SQL server
and I catch it to make my grid update. This works good.
The problem comes when I change the table by a view. I explain: for the
moment, I bring data from a table. But I 'd like to bring data from a view.
So to test it, I made a view of my table and I just change my query in my
application to bring data from the view.
The problem is not that the application doesn't work, but it requires a lot
of CPU time unlike before. I don't understand why its like this.
If someone has an idea....
PAYET Samuel
First, I have an application which display in a grid data from a table in a
SQL server. When the table is modifie, a notification is sent by SQL server
and I catch it to make my grid update. This works good.
The problem comes when I change the table by a view. I explain: for the
moment, I bring data from a table. But I 'd like to bring data from a view.
So to test it, I made a view of my table and I just change my query in my
application to bring data from the view.
The problem is not that the application doesn't work, but it requires a lot
of CPU time unlike before. I don't understand why its like this.
If someone has an idea....
PAYET Samuel