sqlite memory

[tosfera]

Hey guys,

Right now I'm about to start a big project but something is keeping me from starting it. The project has a giant Database diagram and I'd like to hear everyones opinion about sqlite as a file, or a MS sql server. I'm not sure if there is a big differents between it, like I know that a MS sql server can handle alot more, but not sure if it affects the performance of your scripts.

So what do you guys think I should use, I got around 15 to 16 table's with a sh*tload of data.

A: Use sqlite because: ....

B: Use a normal db because: ....

Thanks in advanced!

[tosfera]

No one? Not even 50p, TAPL or solidsnake?

[Castillo]

What do you mean by "normal db" and "sqlite"? do you mean using executeSQLQuery and db functions?

[tosfera]

What do you mean by "normal db" and "sqlite"? do you mean using executeSQLQuery and db functions?

Yeah like, what should I do;

Use a sqlite db or just setup a sql server from microsoft and use that.

edit:

You got 2 ways to connect to a database, sqlite and MySQL. And My question is, wich is the most stable and best running one for a bigger project?

https://wiki.multitheftauto.com/wiki/DbConnect

[tosfera]

Oef, didn't code for 3 days cause of this. :\ Maybe people dind't rly understand my question. So lets try again

I'm starting a giant project thats going to communicate with a database, but to prevert lag I'd like to know wich database type is the best to use. The wiki is pointing you to 2 types of databases:

* Sqlite

* Sqlserver

The thing about the sqlite server is that its just 1 file, but you can't look into it to check some values. Wich you can do in a sqlserver. Another thing as security is that its harder to rip the database of the server, but if they rip the file they can't see the values in it without lua knowledge and the table names. The thing I'm trying to find out right now is:

Wich database type/service thing is the best to use comparing to the other one. Its going to be about 15/16 table's with alot of data in it.

Maybe its alittle more clear now.