|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| Optimizing Data |
| Author |
Message |
|
|
| Posted : 2007-06-13 01:03:25 |
Could somebody tell me please if this sounds right? I've chosen the "The end of yesterday" option and I am using NOSYNC for my queries using PHP because the queries were taking forever otherwise. This means that users will have data that is at most 24 hours old right?
Is it possible to have the users "Load Updated Data" or "Reload All Data" from a web interface?
 |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-06-13 02:00:08 |
Sorry that's a bad option. The best option is:- "The start of every new connection (with "Load Updated Data" first)" because the optimized data is updated automatically upon a new connection and left unupdated until the next new connection occurs again. If you use this option, then you will not need to use the NOSYNC tag in your queries.
See: How do I setup the QODBC Optimizer? Where are the Optimizer options? for all the options and how optimized tables can be updated. |
|
|
|
|
|
| Posted : 2007-06-13 04:36:32 |
| Thanks, I'll read through that link. |
|
|
|
|