On Mon, Dec 12, 2011 at 06:12, David Roe <r...@math.harvard.edu> wrote:
> Yes. I labelled all of the columns as index=True. You should not be indexing all columns, only the ones you are making many queries upon. > I don't know if that's sufficient, or if the size-on-disk would be a lot > less without redundant indices: I haven't used SQL in Sage much. > By this, do you mean the SQLDatabase class defined in sage.databases.sql_db (or sage.database.database for <sage-4.7.2)? If so, this is not necessary, all it does is provide a few extra functions to the python api for sqlite (such as pretty printing of queries). Assuming you are not creating a new class, then you might as well use the python api directly. If you are creating class, and want the extra functionality from SQLDatabase, you can still use the python api directly with self.__database. -- Andrew -- To post to this group, send an email to sage-devel@googlegroups.com To unsubscribe from this group, send an email to sage-devel+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sage-devel URL: http://www.sagemath.org
