Normal Topic Message database (Read 5431 times)
cbislander
Full Member
***
Offline



Posts: 103
Joined: Mar 22nd, 2018
Message database
Feb 25th, 2022 at 4:49pm
Print Post Print Post  
I was trying to create a system that could swap messages among the staff.  We do have separate locations so I made the database and put it on our cloud drive.

The way it works is I have a local Sesame database that is used to generate the message.  It uses XResultSet to post and retrieve to the cloud drive (Z:) in this case. 

The problem is the Database is slow and sometimes it locks up.

Suggestions.
  

MESSAGE-PIC.png ( 241 KB | 43 Downloads )
MESSAGE-PIC.png
Back to top
 
IP Logged
 
BWETTLAUFER
Full Member
***
Offline



Posts: 216
Location: Cambridge, Ontario
Joined: Apr 9th, 2010
Re: Message database
Reply #1 - Mar 14th, 2022 at 8:38pm
Print Post Print Post  
Hey CB -- I run a Sesame database over 6 locations ... sometimes it's the way your network is set up (ask me how I know this). 

If you ping or tracert your cloud drive, is there a lag at all?
  
Back to top
IP Logged