Web2py migrates the model of your database without problem, but not your
data.
Short tutorial
1. To export your sqlite database, use the shell:
db.export_to_csv_file(open('somefile.csv', 'wb'))
2. create a empty postgresql database, and change
db = DAL('sqlite://storage.sqlite')
to
# db = DAL('sqlite://storage.sqlite') # if not, use SQLite or
other DB
db = DAL("postgres://user:passw...@localhost:5432/yournewdatabase")
3. and to import:
db.import_from_csv_file(open('somefile.csv', 'rb'))
2009/11/23 harshit agrawal <harsh.agrawal2...@gmail.com>
>
> This is a fact.
>
> Sir I am almost done with all the queries in my project using the
> default sqlite and now I want to put the portal on apache server. How
> can we do this?
>
> On Nov 23, 12:47 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> > On Nov 23, 11:36 am, harshit agrawal <harsh.agrawal2...@gmail.com>
> > wrote:
> >
> > > But sir my portal will start at a specific time and around 200-250
> > > users will login at the same time then the system may hang.
> >
> > Is this an assumption or a fact?
> >
> > > Also there is a file named options_std.py, in this file what does
> > > 'no_of_threads' means....
> >
> > that is the number of concurrent threads with wsgiserver. It should
> > not be relevant in a production environment.
> >
> > In a production environment you should use apache2+mod_wsgi and let
> > Apache deal with concurrency and serving static files. You should also
> > use postgresql (or other database) not the default sqlite. sqlite
> > always locks the entire database on every request.
> >
> > You can read more on this in chapter 11 of the book and the source of
> > this script:http://www.web2pyslices.com/main/slices/take_slice/29
> >
> > Massimo
> >
> > > reply as soon as possible
> >
> > > Thank You
> > > Harshit
> >
> > > On Nov 23, 10:15 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
> >
> > > > It really depends on many issues. 200 users are not going to make 1
> > > > request/second but more like 1 request every ten seconds each or
> less.
> > > > That means you need to handle 20 requests/seconds.
> >
> > > > On my laptop an average dynamic page takes ~20ms, and that means 50
> > > > requests/second. This means I can handle 200 current users on my
> > > > laptop.
> >
> > > > The bottleneck is always database access. It really depends on what
> > > > those users do with the database.
> >
> > > > Massimo
> >
>
--
Atenciosamente
--
=========================
Alexandre Andrade
Hipercenter.com
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
