 |
adamwalker
Apprentice
Joined: 12 Mar 2005
Posts: 195
|
 Posted: Mon Nov 27, 2006 12:16 pm
[Question - not bug] Databse over Variables
|
I was wondering is there an advantage or a speed difference in using a database to store data over a variable? apart fom the obvious easier sorting of data
Thanks |
|
|
|
|
chris-74269
Magician
Joined: 23 Nov 2004
Posts: 364
|
Posted: Mon Nov 27, 2006 6:55 pm
|
the database i use to store information takes about 5-6 seconds to query and add new information(so slow i stopped using it) it's about 3000 records in size when i stopped using it, so i would suggest going with a variable although at around 3000 keys in a variable i don't know how fast that would be either.
|
|
|
|
|
Iceclaw
Apprentice
Joined: 11 Sep 2005
Posts: 124
|
Posted: Mon Nov 27, 2006 8:12 pm
|
I've not managed to get everything ported over to Cmud yet, but my experience with Zmud was that Databases were faster, if you weren't needing to constently switch between multiple databases.
|
|
|
|
|
Zugg
MASTER
Joined: 25 Sep 2000
Posts: 23379
Location: Colorado, USA
|
Posted: Mon Nov 27, 2006 10:06 pm
|
Also, keep in mind that the database module is not a true database. It doesn't have indexes or anything like that. When the database module is rewritten next year to use a real SQL database format, then you will see some pretty huge performance improvements in the database. So that's something to look forward to.
|
|
|
|
|
|
|
|
