SQLite is big better?

[jfxwave]

Is one db better then many db or one db with many tables?

My project is kind of big but i can't really test the speed until it's used over time. As of now i have 1 db with 6 tables and 7 db with 1 to 2 tables in each. Would it be better to join all of them in to one or take the 1 big one and spit it up?

thanks
Jean

[bule]

That is a very small amount of tables. Feel freely to put them in one database.

[azmanar]

I have 42 tables in 1 db .... runs real quick ... alrite

and holding a few hundred records ......

[stickck]

i have one DB with one Table and it has 1989 records. it runs just as quick now as it did with just 1 record.

chris

[jfxwave]

Thanks guys;)

I just didn't know what was better plus i was thinking about what would happen using my project over a long time (years)



Jean