OpenEuphoria

Re: Big problem to solve

• Posted by Bernie Ryan <xotron at bluefrog.com> Nov 10, 2006
• 557 views

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