1. Big problem to solve
I have a customer running EU 2.4 and win32 lib 59.1 and Matt's ODBC wrapper
connecting to a MySql data base on a server. 6 workstations connect to the
server and run great. Fast and never a problem. However yesterday running the
programs on the server directly got so slow that it takes 5 minutes to
run a report that takes only 2 seconds on the 6 workstations. This is true for
any program that accesses the data base. All other window functins work fine.
This happened all of a sudden. Something is wrong with the server (all
computers are running XP pro) and I've no idea. Any suggestions would be
appreciated.
2. Re: Big problem to solve
George Walters wrote:
>
>
> I have a customer running EU 2.4 and win32 lib 59.1 and Matt's ODBC wrapper
>
> connecting to a MySql data base on a server. 6 workstations connect to the
> server and run great. Fast and never a problem.
Let's call this case 1.
>However yesterday running the
> programs on the server directly
Is this the way you did case 1, directly?
>got so slow that it takes 5 minutes to
> run a report that takes only 2 seconds on the 6 workstations. This is true
> >for
> any program that accesses the data base.
This data base is all on the server?
>All other window functins work fine.
This means non Euphoria functions?
> This happened all of a sudden. Something is wrong with the server (all
> computers are running XP pro) and I've no idea. Any suggestions would be
> appreciated.
Hello George,
I'm not sure this will help but I'm not real clear on the problem.
Don Cole
3. Re: Big problem to solve
Don,
1. The data base is (all tables) is on the "server" (which is just another xp
pro computer)
2. The application is all EU programs and accessing the data base from all
other workstations work as expected, which suggests that the daba base
itself is ok.
3. Running the same EU programs on the server directly it takes 10 seconds to
retreive 1 customer record whereas on the other workstations it is
instantly.
4. I can use mysql directly on the server with a query and it is instantly
responsive as expected.
I'm assuming here that the problem is with Mysql/ODBC but I guess it could be
some other corruption that makes EU stuff go into "very slow" mode.
All non EU items on the computer work fine. Explorer, browsing, notepad etc
work as expected.
Hopefully this is a little clearer.
4. Re: Big problem to solve
George Walters wrote:
>
> Don,
>
> 1. The data base is (all tables) is on the "server" (which is just another xp
> pro computer)
> 2. The application is all EU programs and accessing the data base from all
> other workstations work as expected, which suggests that the daba base
> itself is ok.
> 3. Running the same EU programs on the server directly it takes 10 seconds to
> retreive 1 customer record whereas on the other workstations it is
> instantly.
> 4. I can use mysql directly on the server with a query and it is instantly
> responsive as expected.
>
> I'm assuming here that the problem is with Mysql/ODBC but I guess it could be
> some other corruption that makes EU stuff go into "very slow" mode.
>
> All non EU items on the computer work fine. Explorer, browsing, notepad etc
> work as expected.
>
> Hopefully this is a little clearer.
George:
It could be that the server is low on memory and needs to
have more memory installed on it.
The workstations would be using their individual memory to process but
when you are running a program on the server and it is processing access
request all the work and the program is using server memory.
Bernie
My files in archive:
WMOTOR, XMOTOR, W32ENGIN, MIXEDLIB, EU_ENGIN, WIN32ERU, WIN32API
Can be downloaded here:
http://www.rapideuphoria.com/cgi-bin/asearch.exu?dos=on&win=on&lnx=on&gen=on&keywords=bernie+ryan
5. Re: Big problem to solve
If this were true it lost memory because it has been working properly for
6 months and yesterday started this slow business. It shows 500mb on
control panel > system which should be OK....I think
6. Re: Big problem to solve
George Walters wrote:
>
> If this were true it lost memory because it has been working properly for
> 6 months and yesterday started this slow business. It shows 500mb on
> control panel > system which should be OK....I think
Do You mean that the program was running on this server without any problem for
6 month?
If so, have you installed an application or antivirus or started a service
lately on this machine?
Use task manager to check cpu usage to see what process is grabbing it.
Click on cpu column to order process by cpu usage.
If the processor column is not visible goto display menu and check it.
NOTE: a better tool than windows task manager is Sysinternals one, and its free.
www.sysinternals.com this can be of great help debugging such problem.
regards,
jacques deschênes
7. Re: Big problem to solve
Thanks, do you know how to launch the task manager remotely using "remote
desktop"? when I ctrl-alt-del it launches mine, not the remote one.
8. Re: Big problem to solve
George Walters wrote:
>
> If this were true it lost memory because it has been working properly for
> 6 months and yesterday started this slow business. It shows 500mb on
> control panel > system which should be OK....I think
George:
How can you check memory and at the same time run a program
on the server remotely ?
When Windows needs more memory it moves things out to the
swap file when this happens the system will seem to slow down
while it is swapping programs in and out to the swap file. The
size of the swap file also will effect how much and how often it swaps
out programs.
Ask your user's to stop using the server and then run the server
by it self. If the sever speeds up then it is probably not enough
memory or too small a swap file.
Be careful playing with the swap file when you are running remotely
and not on site.
Bernie
My files in archive:
WMOTOR, XMOTOR, W32ENGIN, MIXEDLIB, EU_ENGIN, WIN32ERU, WIN32API
Can be downloaded here:
http://www.rapideuphoria.com/cgi-bin/asearch.exu?dos=on&win=on&lnx=on&gen=on&keywords=bernie+ryan
9. Re: Big problem to solve
I didn' test it in remote session but try ctrl-shift-esc
if this open the local task maganer then on the remote machine goto start menu -
run... and lunch taskmgr.exe
George Walters wrote:
>
> Thanks, do you know how to launch the task manager remotely using "remote
> desktop"? when I ctrl-alt-del it launches mine, not the remote one.
10. Re: Big problem to solve
- Posted by Ryan W. Johnson <ryanj at fluidae.com>
Nov 10, 2006
-
Last edited Nov 11, 2006
jacques deschênes wrote:
>
> I didn' test it in remote session but try ctrl-shift-esc
> if this open the local task maganer then on the remote machine goto start menu
> - run... and lunch taskmgr.exe
>
> George Walters wrote:
> >
> > Thanks, do you know how to launch the task manager remotely using "remote
> > desktop"? when I ctrl-alt-del it launches mine, not the remote one.
Or, right-click on the taskbar, click on Task Manager.
~Ryan W. Johnson
Fluid Application Environment
http://www.fluidae.com/
[cool quote here, if i ever think of one...]
11. Re: Big problem to solve
Hello again George,
So you are saying that when you run the Eu program from a workstation everything
is ok. But when you run it from the server itself. It's to slow?
Don Cole
12. Re: Big problem to solve
- Posted by George Walters <gwalters at sc.rr.com>
Nov 12, 2006
-
Last edited Nov 13, 2006
Don, that's exactly it. A program that should take 2 seconds takes 5 minutes.
I have solved this problem!!!! Glory!! Some bug somewhere enabled tracing
on the ODBC data sources. I saw this comment on some forum to check it.
Getting rid of it solved the problem. I've know idea how it got set on.
Thanks all for taking the time to listen and respond
--------------------------------------------------------------------------------
