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
Post a Comment