Hi

I thought I would start a new thread with my experiences. I plan to run EDB in the cloud with users connecting to it from remote locations over ADSL and Broadband dongle.

Just rented a VPS running Hyper V.

Just rented a high end server on the net for testing the backend database 4gb Memory 4 cpus

Its up now!!!!! Got it on a monthly contract so if my I have problems nothing lost. Awesome! Its got failsafe - if the server crashes and burns it falls back to server B then Server C etc instantly. Also no backup problems as it gets backed up automatically every 2 hours. 2 i.p's unlimited bandwidth.

Looking forward to trying it out over the w/e. Should be able to have something up to test early next week.

Three click setup and no control panel. Just Login to the server with the remote desktop and you see a Win 2008 Server - do what you like £88pm/$188pm.

If it does the job the client wont be bothered about the price. Also I need to know that if its slow its not the server or the connection, its a flawed idea or flawed software rather than the server/infrastructure.

Peter

I got this up and running through Fasthosts in 10 minutes.

I have a reseller account and just added it in the control panel. I got an eMail 10minutes later to say it was up and running with my Login details.

Unfortunately I had other work this afternoon and couldnt test it.

Just connected to it. Loaded Remote Desktop, put the IP and my user name and password and bingo! Flying!

So far, so good. I was remote controlling the Server and it was so fast that I thought for a moment I was still controlling my own PC in the office!

I have a holiday home (paid for by DBISAM - thanks Tim!).  Here I cant have ADSL so I am connected over the mobile phone network.  The signal is non-existant in the house and I have an antenna on the roof with a donmgle enabled wifi router.

Tomorrow going to load DBISAM on the server with 1gb of data and connect to it with some software that holds open around 20 table queries - lets see how it goes!

Peter

Well I got this up and running this evening in about 3 hours. Got the FTP site working after a few hiccups. FireFTP would not connect to it and I couldnt figure out what I had done wrong with the site on the server.  Anyway changed to filezilla and the problems went away, uploaded DBISAM and the utilities and had the database up and running in a few minutes.

Connected to the data with my app and had to say rather disppointed. Really quite slow. Its a diary app I wrote in 2005 that I am going to adapt , it uses TMS components.

When I change days it takes around 4 seconds which is quite surprising as it only takes less than 2 secs to load a web page.

I am connecting over a dongle and a speedtest is showing 116ms ping 3.6mbps down and  1mbps up.  When I am logged onto the server and I run IExplorer I can open my own website in 1sec which suggests its not the server connection speed/infrastructure thats causing this.

Any ideas?

Peter

Peter


If you're using a TMS grid in unbound mode (ie either TAdvStringGrid or TDBAdvGrid with pagemode set to false) you'll be downloading the entire table.

Also you don't say if you're operating in C/S or F/S mode. The latter will definitely cause a lot more traffic.

Finally if there are lookups that can also cause traffic flows.

Roy Lambert [Team Elevate]

Roy Lambert wrote:

Peter


If you're using a TMS grid in unbound mode (ie either TAdvStringGrid or TDBAdvGrid with pagemode set to false) you'll be downloading the entire table.

Also you don't say if you're operating in C/S or F/S mode. The latter will definitely cause a lot more traffic.

Finally if there are lookups that can also cause traffic flows.

Roy Lambert [Team Elevate]

Hi

no i'm not using the unbound mode, just the DBPlanner.

I am operating in client  server. Also I have the same problem in DBSys so it cant be the grid.

I have uploaded ElevateDB and its quite a lot faster although connecting to the DB is quite slow - 20 seconds. Accessing the data is comparatively painless compared to DBISAM - its faster.  I am having a problem with the SQL Window it does not appear. I have started a seperate thread for this maye I an doing somethiong wrong!!!!

Peter

Ok sorted that, I need to go 'File/new/statement.

Guess its all part of the learning curve.

Also at the moment I am connecting over a dongle as I am at my holiday home not in my normal office where I have a land line.  I also dont have a brilliant signal.  I will setup the software tomorrow to run against EDB and get someone to connect to it over ADSL.

However, hopefully this is my 'worst case scenario'. I have told the client they need ADSL with a dongle as a fall back.

If it works at all over a dongle its a result as it is a fall back/worst case scenario.

Peter

Peter,

<< I have uploaded ElevateDB and its quite a lot faster although connecting
to the DB is quite slow - 20 seconds. >>

If you're using the EDB Manager, then there's going to be a lot of things
going on during connection time that won't be present in a normal
application.  Specifically, the EDB Manager performs a *lot* of small
queries to load the metadata from the system information tables.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim

my speed has increased dramatically with the app I have built since I started pinging the server.
I have had the app up for several hours on the mobile network with no problems at all. Also I note that by pinging the server there is less latency. On the mobile network if there is no activity it drops back from HDSPA to 3G causing a terrible lag (of a couple of settings) when activating a data operation as it needs to light up the HDSPA.  You can see the light change from blue (3G) to HDSPA (green) on the dongle. Noticeable also during a web browsing session when you have been idle for a few minutes.

Now I am pinging the server its keeping the HDSPA lit up and pops a data linked Edit form in around 1.5 secs which I think is awesome over a mobile phone network.

Likewise if I run a query (search) returning a small set displays on screen in <3 seconds. Thats with the TMS Diary component which is no speed freak at the best of times.

I have a poor mobile phone signal anyway and latency over the mobile network is a problem.

Overall brilliant result.

Peter

Peter,

<< Overall brilliant result. >>

Beautiful, thanks.

--
Tim Young
Elevate Software
www.elevatesoft.com