Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

Re: Scalable application with perl

by QuillMeantTen (Friar)
on Apr 26, 2016 at 13:24 UTC ( #1161545=note: print w/replies, xml ) Need Help??

in reply to Scalable application with perl

Question 1 : you probably use perl on the server side so 1 and 2 are kinda redundant. I think you will want to use a framework if you are not using one, because they do make building applications easier.
You will probably also want to look at the kind of code the server side will be running. If its only some crud then it should not take much resources but if each client represent a heavy calculation load then you might want to tune your code for performance when it comes to those calculations. If profiling and optimising is not enough then you might think about rewriting those parts in c/c++ (choice depending on the size of the program needed for said calculations, but choosing between c and c++ is an entirely different can of worms that I won't open here), ideally as a bunch of scriptable primitives.

On the database side, its something else entirely. What can be told depends greatly on what you know. What do you know about database management? ACID properties? What solution are you currently using?

you should start finding out how your current solution does when it comes to respecting them. Then again do some profiling, build indexes where they are needed, you probably wont have to rewrite your queries because most dbms nowadays have good optimizers... Basically you want the smallest possible transactions so you can do a bunch of them as fast as possible and easily recover from a database crash.

Previous paragraph assumes that your database is well designed, of course, if you have doubts on that topic then you might want to normalize it.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1161545]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (6)
As of 2022-05-16 10:07 GMT
Find Nodes?
    Voting Booth?
    Do you prefer to work remotely?

    Results (62 votes). Check out past polls.