Results 1 to 10 of 10

Thread: Database hardiness

  1. #1
    Senior Member
    Join Date
    Apr 2013
    Location
    Soledad, Atlántico, Colombia
    Posts
    117

    Post Database hardiness

    How many hardiness is the Lianja database?

    manage Lianja native DBC databases (and DBF tables)?
    how is the storage limit? (in VFP is than 2 Gb)

    Manage Lianja SQL (or MySQL) databases (and tables) or use a owner manager?

    Thanks.

    Victor Navarro
    Barranquilla, COLOMBIA
    3008102508
    ICQ 279 364 380
    Face: +573008102508
    MSN: eres_un_vago@hotmail.com
    Mail: eres_un_vago@yahoo.es
    Whatsapp: +573008102508
    Skype: eres_un_vago
    PIN: 7A3F5E60

  2. #2
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,882
    I decided to migrate the DB to MS SQL Server Express.
    Using a simple application (DataBanse.NET) to manage quickly see table structures and data.
    Then, with the Virtual Table, I crete and manage data into Lianja.

    Fabio

  3. #3
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,268
    What does that answer have to do with his question?

  4. #4
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,882
    Sorry, I can delete it?

  5. #5
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,268
    Victor,

    The lianja database engine is full 64 bit and has no practical file size limits as is detailed on the product pages.

    It has self healing indexes and is widely deployed around the world in defense, banking and finance systems.

    It is embedded in lianja app builder, lianja sql server and lianja cloud server.

    It is fast and lightweight.

    It is easy to install.

    It comes with both an odbc driver and a jdbc driver.

    It handles transparent connectivity to third party databases using virtual tables.

    You can write stored procedures and triggers in VFP.

    So, to summarize, there are many advantages to it.

  6. #6
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,882
    One question:
    if I create a local DB with Lianja app builder, then I decide to use Lianja SQL Server, I have to rewrite my app to use the tables through ODBC?

    thanks
    Fabio

  7. #7
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,890
    You should also tell him that MSSQL Express is limited to running on 1 CPU or 4 cores and has a maximum table size of 10GB. It also will only use up to a maximum of 1GB of memory.

    None of these are true about Lianja SQL Server which will utilize all CPUs and cores without limitation.
    Last edited by barrymavin; 2014-06-05 at 08:01.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  8. #8
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,882
    Quote Originally Posted by barrymavin View Post
    None if these are true about Lianja SQL.
    This is for me?

  9. #9
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,890
    Create another thread. That also has nothing to do with his question.

    If you build an app against "local" virtual tables you can switch the connection at runtime. It's in the app settings.

    You have asked this type of question many times.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  10. #10
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,268
    Quote Originally Posted by phabio View Post
    This is for me?
    Read the whole thread. I bothered myself to lookup the limitations of MSSQL Express.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us