Recently MY ISP began migrating my VMWARE 2008 Server to some new SANS arrangement. This became a performance nightware, which has come close to me being arrested for abuse and aggresion on a Manager of an an international company for there incompetence. (Long ugly Story)
Anyhow also in this time I began seeking ways to boost the performance.
With the disk migration I discovered that alpha 5 was not truly closing tables after using something like tbl.close(). It appears that while the table was closed, and could how be reopened exclusively, infact there still lingered a thread and handle to the SANS drive. This in turn would clutter the CPU process, slowing the CPU and then in turn bloat the Memory. AS the memory needed to page, and the SANS was already busy, this just meant everything just got worse.
This seems to be a peculiarity to The SANS disk arangemnt.
I reinstalled my homeserver and altered the name-server, and discovered that everything worked reasonable except I have slow upload speed from home, Which is why I went to VMWARE.
Now the unexplained revelation,
My principal code is aproximately 130,000 lines of A5 broken into 8 AJAX.a5w files. I'd say the server is 95% busy with AJAX.
-
By altering the standard code I have written I have discovered there is only one way to close the tables safely and easily and it is through the use
of the END statement
-
it is that simple!
I have moved back to the VMWARE server and the speed, response, is incredibly better. I was going to upgrade to the Ver10 Server for speed, but it will no longer be necessary.
Anyhow also in this time I began seeking ways to boost the performance.
With the disk migration I discovered that alpha 5 was not truly closing tables after using something like tbl.close(). It appears that while the table was closed, and could how be reopened exclusively, infact there still lingered a thread and handle to the SANS drive. This in turn would clutter the CPU process, slowing the CPU and then in turn bloat the Memory. AS the memory needed to page, and the SANS was already busy, this just meant everything just got worse.
This seems to be a peculiarity to The SANS disk arangemnt.
I reinstalled my homeserver and altered the name-server, and discovered that everything worked reasonable except I have slow upload speed from home, Which is why I went to VMWARE.
Now the unexplained revelation,
My principal code is aproximately 130,000 lines of A5 broken into 8 AJAX.a5w files. I'd say the server is 95% busy with AJAX.
-
By altering the standard code I have written I have discovered there is only one way to close the tables safely and easily and it is through the use
of the END statement
-
Code:
if action = "Dostuff" Dim TBL as P TBL = table.open("testTable.dbf) ''' Do statements etc [B]END[/B] end if
I have moved back to the VMWARE server and the speed, response, is incredibly better. I was going to upgrade to the Ver10 Server for speed, but it will no longer be necessary.
Comment