Database hardiness

[K!k3]

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

[phabio]

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

[lianjasupport]

What does that answer have to do with his question?

[phabio]

Sorry, I can delete it?

[lianjasupport]

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.

[phabio]

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

[barrymavin]

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.

[phabio]

None if these are true about Lianja SQL.

This is for me?

[barrymavin]

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.

[lianjasupport]

This is for me?

Read the whole thread. I bothered myself to lookup the limitations of MSSQL Express.