I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
Nope... not possible.
Nor should you build your application logic in such a way that it depends on a specific server responding as you are introducing state into the application.
+++ Rick ---
Dear Rick,
I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
West Wind Technologies
Making waves on the Web
from Maui
Is there no way to close and open data in EXE servers automatically?
Many thanks again :)
Nope... not possible.
Nor should you build your application logic in such a way that it depends on a specific server responding as you are introducing state into the application.
+++ Rick ---
Dear Rick,
I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
Secondly, you must add a timer to your program. This timer can either check the actual time and close the files when this time arises. However, this is not a good idea. A better solution is to let the timer check for a specific file name, for instance "process.stop". If this file exists, your program closes the tables, and reopens them when the file is gone. This means that your maintenance program must create this file, and delete it when it 's finished.
I am sorry. I need to close tables in every EXE server at precise time for reindex maintenance procedure. The four servers share the same tables. The procedure should run automatically, but I would not put a timer in every EXE server for performances reasons.
Is there no way to close and open data in EXE servers automatically?
Many thanks again :)
Nope... not possible.
Nor should you build your application logic in such a way that it depends on a specific server responding as you are introducing state into the application.
+++ Rick ---
Dear Rick,
I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
thank you for attention.
The application is under high traffic volume, so do you think adding a timer to it could compromise performance?
I did look for an external timer just for this reason. However an external timer is not able to close data in all four EXE servers because they reply randomly to calls.
Sincerely
First of all, if you need to reindex regularly, you have a problem which I strongly recommend that you fix. If not, you may have a much bigger problem sooner or later.
Secondly, you must add a timer to your program. This timer can either check the actual time and close the files when this time arises. However, this is not a good idea. A better solution is to let the timer check for a specific file name, for instance "process.stop". If this file exists, your program closes the tables, and reopens them when the file is gone. This means that your maintenance program must create this file, and delete it when it 's finished.
I am sorry. I need to close tables in every EXE server at precise time for reindex maintenance procedure. The four servers share the same tables. The procedure should run automatically, but I would not put a timer in every EXE server for performances reasons.
Is there no way to close and open data in EXE servers automatically?
Many thanks again :)
Nope... not possible.
Nor should you build your application logic in such a way that it depends on a specific server responding as you are introducing state into the application.
+++ Rick ---
Dear Rick,
I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
But I will repeat what I just wrote, if you need to reindex you should prioritize to solve your problem. The most frequent reason for index corruption is an index key which can give a variable length, for instance trim(). Show me the index keys, and I may be able to spot the bad index expression.
Dear Tore,
thank you for attention.
The application is under high traffic volume, so do you think adding a timer to it could compromise performance?
I did look for an external timer just for this reason. However an external timer is not able to close data in all four EXE servers because they reply randomly to calls.
Sincerely
First of all, if you need to reindex regularly, you have a problem which I strongly recommend that you fix. If not, you may have a much bigger problem sooner or later.
Secondly, you must add a timer to your program. This timer can either check the actual time and close the files when this time arises. However, this is not a good idea. A better solution is to let the timer check for a specific file name, for instance "process.stop". If this file exists, your program closes the tables, and reopens them when the file is gone. This means that your maintenance program must create this file, and delete it when it 's finished.
I am sorry. I need to close tables in every EXE server at precise time for reindex maintenance procedure. The four servers share the same tables. The procedure should run automatically, but I would not put a timer in every EXE server for performances reasons.
Is there no way to close and open data in EXE servers automatically?
Many thanks again :)
Nope... not possible.
Nor should you build your application logic in such a way that it depends on a specific server responding as you are introducing state into the application.
+++ Rick ---
Dear Rick,
I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
I am thinking to set a timer to check every hour, so I hope it do not influece performances.
The following are index tags of the critical table.
FINE and INIZIO are Datetime fields.
CF and CHIAMATA are 25 Characters fields.
Others ones are Numeric fields.
Do you think TTOD() could be unstable?
INDEX ON IDCF TAG IDCF
INDEX ON IDCHIAMATA TAG IDCHIAMATA
INDEX ON IDTLK TAG IDTLK
INDEX ON FINE TAG FINE
INDEX ON TTOD(FINE) TAG DFINE
INDEX ON INIZIO TAG INIZIO
INDEX ON IDRECORD TAG IDRECORD
INDEX ON IDFUNZIONA TAG IDFUNZIONA
INDEX ON CF TAG CF
INDEX ON CHIAMATA TAG CHIAMATA
No, a timer won't influence the performance much, unless you set it to a very low value. We did the same in a "web shop" I ran earlier. When the file existed, the users were routed to static page with a message that backup was run, and that they should try again soon. When the file was deleted, they were routed back again.
But I will repeat what I just wrote, if you need to reindex you should prioritize to solve your problem. The most frequent reason for index corruption is an index key which can give a variable length, for instance trim(). Show me the index keys, and I may be able to spot the bad index expression.
Dear Tore,
thank you for attention.
The application is under high traffic volume, so do you think adding a timer to it could compromise performance?
I did look for an external timer just for this reason. However an external timer is not able to close data in all four EXE servers because they reply randomly to calls.
Sincerely
First of all, if you need to reindex regularly, you have a problem which I strongly recommend that you fix. If not, you may have a much bigger problem sooner or later.
Secondly, you must add a timer to your program. This timer can either check the actual time and close the files when this time arises. However, this is not a good idea. A better solution is to let the timer check for a specific file name, for instance "process.stop". If this file exists, your program closes the tables, and reopens them when the file is gone. This means that your maintenance program must create this file, and delete it when it 's finished.
I am sorry. I need to close tables in every EXE server at precise time for reindex maintenance procedure. The four servers share the same tables. The procedure should run automatically, but I would not put a timer in every EXE server for performances reasons.
Is there no way to close and open data in EXE servers automatically?
Many thanks again :)
Nope... not possible.
Nor should you build your application logic in such a way that it depends on a specific server responding as you are introducing state into the application.
+++ Rick ---
Dear Rick,
I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
Dear Tore,
I am thinking to set a timer to check every hour, so I hope it do not influece performances.
The following are index tags of the critical table.
FINE and INIZIO are Datetime fields.
CF and CHIAMATA are 25 Characters fields.
Others ones are Numeric fields.
INDEX ON IDCF TAG IDCF
INDEX ON IDCHIAMATA TAG IDCHIAMATA
INDEX ON IDTLK TAG IDTLK
INDEX ON FINE TAG FINE
INDEX ON TTOD(FINE) TAG DFINE
INDEX ON INIZIO TAG INIZIO
INDEX ON IDRECORD TAG IDRECORD
INDEX ON IDFUNZIONA TAG IDFUNZIONA
INDEX ON CF TAG CF
INDEX ON CHIAMATA TAG CHIAMATA
No, a timer won't influence the performance much, unless you set it to a very low value. We did the same in a "web shop" I ran earlier. When the file existed, the users were routed to static page with a message that backup was run, and that they should try again soon. When the file was deleted, they were routed back again.
But I will repeat what I just wrote, if you need to reindex you should prioritize to solve your problem. The most frequent reason for index corruption is an index key which can give a variable length, for instance trim(). Show me the index keys, and I may be able to spot the bad index expression.
Dear Tore,
thank you for attention.
The application is under high traffic volume, so do you think adding a timer to it could compromise performance?
I did look for an external timer just for this reason. However an external timer is not able to close data in all four EXE servers because they reply randomly to calls.
Sincerely
First of all, if you need to reindex regularly, you have a problem which I strongly recommend that you fix. If not, you may have a much bigger problem sooner or later.
Secondly, you must add a timer to your program. This timer can either check the actual time and close the files when this time arises. However, this is not a good idea. A better solution is to let the timer check for a specific file name, for instance "process.stop". If this file exists, your program closes the tables, and reopens them when the file is gone. This means that your maintenance program must create this file, and delete it when it 's finished.
I am sorry. I need to close tables in every EXE server at precise time for reindex maintenance procedure. The four servers share the same tables. The procedure should run automatically, but I would not put a timer in every EXE server for performances reasons.
Is there no way to close and open data in EXE servers automatically?
Many thanks again :)
Nope... not possible.
Nor should you build your application logic in such a way that it depends on a specific server responding as you are introducing state into the application.
+++ Rick ---
Dear Rick,
I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
FINE field is never empty, always with datetime compiled.
Can FINE be .null. or empty?
Dear Tore,
I am thinking to set a timer to check every hour, so I hope it do not influece performances.
The following are index tags of the critical table.
FINE and INIZIO are Datetime fields.
CF and CHIAMATA are 25 Characters fields.
Others ones are Numeric fields.
INDEX ON IDCF TAG IDCF
INDEX ON IDCHIAMATA TAG IDCHIAMATA
INDEX ON IDTLK TAG IDTLK
INDEX ON FINE TAG FINE
INDEX ON TTOD(FINE) TAG DFINE
INDEX ON INIZIO TAG INIZIO
INDEX ON IDRECORD TAG IDRECORD
INDEX ON IDFUNZIONA TAG IDFUNZIONA
INDEX ON CF TAG CF
INDEX ON CHIAMATA TAG CHIAMATA
No, a timer won't influence the performance much, unless you set it to a very low value. We did the same in a "web shop" I ran earlier. When the file existed, the users were routed to static page with a message that backup was run, and that they should try again soon. When the file was deleted, they were routed back again.
But I will repeat what I just wrote, if you need to reindex you should prioritize to solve your problem. The most frequent reason for index corruption is an index key which can give a variable length, for instance trim(). Show me the index keys, and I may be able to spot the bad index expression.
Dear Tore,
thank you for attention.
The application is under high traffic volume, so do you think adding a timer to it could compromise performance?
I did look for an external timer just for this reason. However an external timer is not able to close data in all four EXE servers because they reply randomly to calls.
Sincerely
First of all, if you need to reindex regularly, you have a problem which I strongly recommend that you fix. If not, you may have a much bigger problem sooner or later.
Secondly, you must add a timer to your program. This timer can either check the actual time and close the files when this time arises. However, this is not a good idea. A better solution is to let the timer check for a specific file name, for instance "process.stop". If this file exists, your program closes the tables, and reopens them when the file is gone. This means that your maintenance program must create this file, and delete it when it 's finished.
I am sorry. I need to close tables in every EXE server at precise time for reindex maintenance procedure. The four servers share the same tables. The procedure should run automatically, but I would not put a timer in every EXE server for performances reasons.
Is there no way to close and open data in EXE servers automatically?
Many thanks again :)
Nope... not possible.
Nor should you build your application logic in such a way that it depends on a specific server responding as you are introducing state into the application.
+++ Rick ---
Dear Rick,
I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
NULL values are not allowed (as default).
FINE field is never empty, always with datetime compiled.
Can FINE be .null. or empty?
Dear Tore,
I am thinking to set a timer to check every hour, so I hope it do not influece performances.
The following are index tags of the critical table.
FINE and INIZIO are Datetime fields.
CF and CHIAMATA are 25 Characters fields.
Others ones are Numeric fields.
INDEX ON IDCF TAG IDCF
INDEX ON IDCHIAMATA TAG IDCHIAMATA
INDEX ON IDTLK TAG IDTLK
INDEX ON FINE TAG FINE
INDEX ON TTOD(FINE) TAG DFINE
INDEX ON INIZIO TAG INIZIO
INDEX ON IDRECORD TAG IDRECORD
INDEX ON IDFUNZIONA TAG IDFUNZIONA
INDEX ON CF TAG CF
INDEX ON CHIAMATA TAG CHIAMATA
No, a timer won't influence the performance much, unless you set it to a very low value. We did the same in a "web shop" I ran earlier. When the file existed, the users were routed to static page with a message that backup was run, and that they should try again soon. When the file was deleted, they were routed back again.
But I will repeat what I just wrote, if you need to reindex you should prioritize to solve your problem. The most frequent reason for index corruption is an index key which can give a variable length, for instance trim(). Show me the index keys, and I may be able to spot the bad index expression.
Dear Tore,
thank you for attention.
The application is under high traffic volume, so do you think adding a timer to it could compromise performance?
I did look for an external timer just for this reason. However an external timer is not able to close data in all four EXE servers because they reply randomly to calls.
Sincerely
First of all, if you need to reindex regularly, you have a problem which I strongly recommend that you fix. If not, you may have a much bigger problem sooner or later.
Secondly, you must add a timer to your program. This timer can either check the actual time and close the files when this time arises. However, this is not a good idea. A better solution is to let the timer check for a specific file name, for instance "process.stop". If this file exists, your program closes the tables, and reopens them when the file is gone. This means that your maintenance program must create this file, and delete it when it 's finished.
I am sorry. I need to close tables in every EXE server at precise time for reindex maintenance procedure. The four servers share the same tables. The procedure should run automatically, but I would not put a timer in every EXE server for performances reasons.
Is there no way to close and open data in EXE servers automatically?
Many thanks again :)
Nope... not possible.
Nor should you build your application logic in such a way that it depends on a specific server responding as you are introducing state into the application.
+++ Rick ---
Dear Rick,
I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
Can FINE be .null. or empty?
Dear Tore,
I am thinking to set a timer to check every hour, so I hope it do not influece performances.
The following are index tags of the critical table.
FINE and INIZIO are Datetime fields.
CF and CHIAMATA are 25 Characters fields.
Others ones are Numeric fields.
INDEX ON IDCF TAG IDCF
INDEX ON IDCHIAMATA TAG IDCHIAMATA
INDEX ON IDTLK TAG IDTLK
INDEX ON FINE TAG FINE
INDEX ON TTOD(FINE) TAG DFINE
INDEX ON INIZIO TAG INIZIO
INDEX ON IDRECORD TAG IDRECORD
INDEX ON IDFUNZIONA TAG IDFUNZIONA
INDEX ON CF TAG CF
INDEX ON CHIAMATA TAG CHIAMATA
No, a timer won't influence the performance much, unless you set it to a very low value. We did the same in a "web shop" I ran earlier. When the file existed, the users were routed to static page with a message that backup was run, and that they should try again soon. When the file was deleted, they were routed back again.
But I will repeat what I just wrote, if you need to reindex you should prioritize to solve your problem. The most frequent reason for index corruption is an index key which can give a variable length, for instance trim(). Show me the index keys, and I may be able to spot the bad index expression.
Dear Tore,
thank you for attention.
The application is under high traffic volume, so do you think adding a timer to it could compromise performance?
I did look for an external timer just for this reason. However an external timer is not able to close data in all four EXE servers because they reply randomly to calls.
Sincerely
First of all, if you need to reindex regularly, you have a problem which I strongly recommend that you fix. If not, you may have a much bigger problem sooner or later.
Secondly, you must add a timer to your program. This timer can either check the actual time and close the files when this time arises. However, this is not a good idea. A better solution is to let the timer check for a specific file name, for instance "process.stop". If this file exists, your program closes the tables, and reopens them when the file is gone. This means that your maintenance program must create this file, and delete it when it 's finished.
I am sorry. I need to close tables in every EXE server at precise time for reindex maintenance procedure. The four servers share the same tables. The procedure should run automatically, but I would not put a timer in every EXE server for performances reasons.
Is there no way to close and open data in EXE servers automatically?
Many thanks again :)
Nope... not possible.
Nor should you build your application logic in such a way that it depends on a specific server responding as you are introducing state into the application.
+++ Rick ---
Dear Rick,
I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
Do you think TTOD() could be unstable in a tag?
Can FINE be .null. or empty?
Dear Tore,
I am thinking to set a timer to check every hour, so I hope it do not influece performances.
The following are index tags of the critical table.
FINE and INIZIO are Datetime fields.
CF and CHIAMATA are 25 Characters fields.
Others ones are Numeric fields.
INDEX ON IDCF TAG IDCF
INDEX ON IDCHIAMATA TAG IDCHIAMATA
INDEX ON IDTLK TAG IDTLK
INDEX ON FINE TAG FINE
INDEX ON TTOD(FINE) TAG DFINE
INDEX ON INIZIO TAG INIZIO
INDEX ON IDRECORD TAG IDRECORD
INDEX ON IDFUNZIONA TAG IDFUNZIONA
INDEX ON CF TAG CF
INDEX ON CHIAMATA TAG CHIAMATA
No, a timer won't influence the performance much, unless you set it to a very low value. We did the same in a "web shop" I ran earlier. When the file existed, the users were routed to static page with a message that backup was run, and that they should try again soon. When the file was deleted, they were routed back again.
But I will repeat what I just wrote, if you need to reindex you should prioritize to solve your problem. The most frequent reason for index corruption is an index key which can give a variable length, for instance trim(). Show me the index keys, and I may be able to spot the bad index expression.
Dear Tore,
thank you for attention.
The application is under high traffic volume, so do you think adding a timer to it could compromise performance?
I did look for an external timer just for this reason. However an external timer is not able to close data in all four EXE servers because they reply randomly to calls.
Sincerely
First of all, if you need to reindex regularly, you have a problem which I strongly recommend that you fix. If not, you may have a much bigger problem sooner or later.
Secondly, you must add a timer to your program. This timer can either check the actual time and close the files when this time arises. However, this is not a good idea. A better solution is to let the timer check for a specific file name, for instance "process.stop". If this file exists, your program closes the tables, and reopens them when the file is gone. This means that your maintenance program must create this file, and delete it when it 's finished.
I am sorry. I need to close tables in every EXE server at precise time for reindex maintenance procedure. The four servers share the same tables. The procedure should run automatically, but I would not put a timer in every EXE server for performances reasons.
Is there no way to close and open data in EXE servers automatically?
Many thanks again :)
Nope... not possible.
Nor should you build your application logic in such a way that it depends on a specific server responding as you are introducing state into the application.
+++ Rick ---
Dear Rick,
I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
Many thanks again.
Sincerely
I am not sure, really. Try to scan the table, and check that every record gives the same key length, that's critical.
Do you think TTOD() could be unstable in a tag?
Can FINE be .null. or empty?
Dear Tore,
I am thinking to set a timer to check every hour, so I hope it do not influece performances.
The following are index tags of the critical table.
FINE and INIZIO are Datetime fields.
CF and CHIAMATA are 25 Characters fields.
Others ones are Numeric fields.
INDEX ON IDCF TAG IDCF
INDEX ON IDCHIAMATA TAG IDCHIAMATA
INDEX ON IDTLK TAG IDTLK
INDEX ON FINE TAG FINE
INDEX ON TTOD(FINE) TAG DFINE
INDEX ON INIZIO TAG INIZIO
INDEX ON IDRECORD TAG IDRECORD
INDEX ON IDFUNZIONA TAG IDFUNZIONA
INDEX ON CF TAG CF
INDEX ON CHIAMATA TAG CHIAMATA
No, a timer won't influence the performance much, unless you set it to a very low value. We did the same in a "web shop" I ran earlier. When the file existed, the users were routed to static page with a message that backup was run, and that they should try again soon. When the file was deleted, they were routed back again.
But I will repeat what I just wrote, if you need to reindex you should prioritize to solve your problem. The most frequent reason for index corruption is an index key which can give a variable length, for instance trim(). Show me the index keys, and I may be able to spot the bad index expression.
Dear Tore,
thank you for attention.
The application is under high traffic volume, so do you think adding a timer to it could compromise performance?
I did look for an external timer just for this reason. However an external timer is not able to close data in all four EXE servers because they reply randomly to calls.
Sincerely
First of all, if you need to reindex regularly, you have a problem which I strongly recommend that you fix. If not, you may have a much bigger problem sooner or later.
Secondly, you must add a timer to your program. This timer can either check the actual time and close the files when this time arises. However, this is not a good idea. A better solution is to let the timer check for a specific file name, for instance "process.stop". If this file exists, your program closes the tables, and reopens them when the file is gone. This means that your maintenance program must create this file, and delete it when it 's finished.
I am sorry. I need to close tables in every EXE server at precise time for reindex maintenance procedure. The four servers share the same tables. The procedure should run automatically, but I would not put a timer in every EXE server for performances reasons.
Is there no way to close and open data in EXE servers automatically?
Many thanks again :)
Nope... not possible.
Nor should you build your application logic in such a way that it depends on a specific server responding as you are introducing state into the application.
+++ Rick ---
Dear Rick,
I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
Ok, I try without this tag.
Many thanks again.
Sincerely
I am not sure, really. Try to scan the table, and check that every record gives the same key length, that's critical.
Do you think TTOD() could be unstable in a tag?
Can FINE be .null. or empty?
Dear Tore,
I am thinking to set a timer to check every hour, so I hope it do not influece performances.
The following are index tags of the critical table.
FINE and INIZIO are Datetime fields.
CF and CHIAMATA are 25 Characters fields.
Others ones are Numeric fields.
INDEX ON IDCF TAG IDCF
INDEX ON IDCHIAMATA TAG IDCHIAMATA
INDEX ON IDTLK TAG IDTLK
INDEX ON FINE TAG FINE
INDEX ON TTOD(FINE) TAG DFINE
INDEX ON INIZIO TAG INIZIO
INDEX ON IDRECORD TAG IDRECORD
INDEX ON IDFUNZIONA TAG IDFUNZIONA
INDEX ON CF TAG CF
INDEX ON CHIAMATA TAG CHIAMATA
No, a timer won't influence the performance much, unless you set it to a very low value. We did the same in a "web shop" I ran earlier. When the file existed, the users were routed to static page with a message that backup was run, and that they should try again soon. When the file was deleted, they were routed back again.
But I will repeat what I just wrote, if you need to reindex you should prioritize to solve your problem. The most frequent reason for index corruption is an index key which can give a variable length, for instance trim(). Show me the index keys, and I may be able to spot the bad index expression.
Dear Tore,
thank you for attention.
The application is under high traffic volume, so do you think adding a timer to it could compromise performance?
I did look for an external timer just for this reason. However an external timer is not able to close data in all four EXE servers because they reply randomly to calls.
Sincerely
First of all, if you need to reindex regularly, you have a problem which I strongly recommend that you fix. If not, you may have a much bigger problem sooner or later.
Secondly, you must add a timer to your program. This timer can either check the actual time and close the files when this time arises. However, this is not a good idea. A better solution is to let the timer check for a specific file name, for instance "process.stop". If this file exists, your program closes the tables, and reopens them when the file is gone. This means that your maintenance program must create this file, and delete it when it 's finished.
I am sorry. I need to close tables in every EXE server at precise time for reindex maintenance procedure. The four servers share the same tables. The procedure should run automatically, but I would not put a timer in every EXE server for performances reasons.
Is there no way to close and open data in EXE servers automatically?
Many thanks again :)
Nope... not possible.
Nor should you build your application logic in such a way that it depends on a specific server responding as you are introducing state into the application.
+++ Rick ---
Dear Rick,
I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
- stop all servers
- load one server -- if exe can access tables exclusive, reindex -- should work
- stop all servers
- load all servers
I am sorry. I need to close tables in every EXE server at precise time for reindex maintenance procedure. The four servers share the same tables. The procedure should run automatically, but I would not put a timer in every EXE server for performances reasons.
Is there no way to close and open data in EXE servers automatically?
Many thanks again :)
Nope... not possible.
Nor should you build your application logic in such a way that it depends on a specific server responding as you are introducing state into the application.
+++ Rick ---
Dear Rick,
I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
-- thn (FoxInCloud)
I would hase an exe using wwHTTP to order the site to :
- stop all servers
- load one server -- if exe can access tables exclusive, reindex -- should work
- stop all servers
- load all servers
I am sorry. I need to close tables in every EXE server at precise time for reindex maintenance procedure. The four servers share the same tables. The procedure should run automatically, but I would not put a timer in every EXE server for performances reasons.
Is there no way to close and open data in EXE servers automatically?
Many thanks again :)
Nope... not possible.
Nor should you build your application logic in such a way that it depends on a specific server responding as you are introducing state into the application.
+++ Rick ---
Dear Rick,
I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
You should be running in COM mode, which allows you to remotely load a single instance of your server pool. Once you have a single instance running only you can do administrative tasks that require EXCLUSIVE data access.
+++ Rick ---
I am sorry. I need to close tables in every EXE server at precise time for reindex maintenance procedure. The four servers share the same tables. The procedure should run automatically, but I would not put a timer in every EXE server for performances reasons.
Is there no way to close and open data in EXE servers automatically?
Many thanks again :)
Nope... not possible.
Nor should you build your application logic in such a way that it depends on a specific server responding as you are introducing state into the application.
+++ Rick ---
Dear Rick,
I have 4 server EXE running together (File based), I know every one of their four _vfp.ProcessID.
I see the four instances to reply randomly to calls.
I would like to redirect a webpage to a precise instance: for example, if 5234 is one of four _vfp.ProcessID then I would like to redirect a web page exactly to that.
Please is it possible?
Thank you veru much
West Wind Technologies
Making waves on the Web
from Maui