sql server - mssql remote application VS web based application -


i have client request develop point of sales system(pos). of pos system using desktop based application.
client request branches not need database installation, , branches directly connected hq server.
kind of requirement suitable web based application,
if m using desktop based application, vb.net develop, , remote access ms sql database.
problem face? stable?

dont bother server down business,
i want know when retrieve huge data web based , desktop based(remote access db) speed of retrieve data differentiate ?

server bandwidth : dedicated 100mb upload , download

mostly... if use remote application, there lot of configurations , troubles can occur when comes types of os user use, instance mac pc or apple product.

visit these sites: site1 , site2 more info. web-based application more convenient desktop based if trying make desktop based , have problems database, can use vb.net , postgresql database not directly connected vb instead have web-based database. don't know how call try having web application renders json format data , call vb code. exact process using get , post method.

you can use code... under module:

public globallink string = "https://samplesite.com/" public sub save(byval link string, byval data string)     request = webrequest.create(link)     request.credentials = credentialcache.defaultcredentials       request.method = "post"     request.contenttype = "application/x-www-form-urlencoded"     postdata = string.format(data)     request.contentlength = postdata.length     bytearray = encoding.ascii.getbytes(postdata)     request.contentlength = bytearray.length     datastream = request.getrequeststream()     datastream.write(bytearray, 0, bytearray.length)     datastream.close()      response = request.getresponse()     datastream = response.getresponsestream()     reader = new streamreader(datastream)     webrep = (ctype(response, httpwebresponse).statusdescription)       datastream = response.getresponsestream()     reader = new streamreader(datastream)      reader.close()     response.close() end sub 

the link literally link , data parameters sent. parameters upon saving...

www.samplesite.com/posdata?id=01&field1=sampledata&field2=sampledata2 

when doing kind of process, used ruby on rails deployed heroku , call vb works well.

the problem when using method when have slow internet connection has no problem you.


Comments

Popular posts from this blog

Email notification in google apps script -

c++ - Difference between pre and post decrement in recursive function argument -

javascript - IE11 incompatibility with jQuery's 'readonly'? -