| Marcus Bointon of Synchromedia on Valentina for Director |
|
Does anyone else need convincing that Access is really not a good way to go? - Marcus Bointon of Synchromedia on Valentina for Director I developed a kiosk project using Paradigma's Valentina database in Macromedia Director (not exactly renowned as a speedy environment), but on a P3/600 with 384 Mb RAM I imported and indexed 20 million records (about 1.2 Gb) inside two hours. I thought I'd do a benchmark with Access 2k - it crashed after 11 hours of importing (not even indexing). Valentina did 5-term OR searches in under 0.1 sec on the entire dataset, Access (using only 10% of the data) clocked in at about 13 sec. So Does anyone else need convincing that Access is really not a good way to go? - Marcus Bointon of Synchromedia on Valentina for Director |