in-memory SQLite database question

Databases
1

Hello,
to create a inMemory database docs offer this code:
Dim inMemoryDB As New SQLiteDatabase
If inMemoryDB.Connect Then
// Can now use inMemoryDB
End If

Now, since I have a window that contains a pagePanel with several panes, each one offering different criteria for performing DB queries, can I make inMemoryDB a property of the window?
Or is it defeating the purpose (speed etc.) of an in-memory database?

Thanks.

2

Yes make it a property. It will still be in memory by virtue of having no database file, so you lose nothing performance wise.

3

Exellent. Thanks.