| Post_Query causes low speed in retrieve data [message #536898] |
Fri, 23 December 2011 14:50  |
HM75
Messages: 9
Registered: April 2008
|
Junior Member |
|
|
I have single datablock inside my form. It is including of some fields related to the X table, also there are some other fields which are related to the other tables.I have set the property of those field in to the non database.I use post_query in order to get data for those mentioned non data base tables.
in post_query I wrote some queries by required tables except X table.for example :
- select a into (my nondatabase field)from Y where Y.Yb = X.Xb
- select d into (my another nondatabase field)from Z where Z.Zb = X.Xb
by using this triger, the speed of retrieving data in my form became very low!
What's your solution?
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
