on 6/22/02 19:50, Marc Van Olmen at marc AT tribeworks .DOT com wrote:
Hi Marc,
> Don't have time to read the whole threads about it:
> So just my personal advice:
>
> * A database that is local is faster then one that is online (server based)
Not very correct.
You mean that network can slow down return of data for query.
But networks are very different: dial-up and 1GB Ethernet.
> * to make your database fast keep the database file itself as small as
> possible. So it is better not to use BLOB and keep the files in an external
> folder.
Totally wrong !!!
Of course size of database affect general performance -- it is faster search
table with 1000 records than table with 10 millions of records.
But! Valentina has smart storage of BLOBs, so they DO NOT affect in any way
speed of search for table.
> * when you store URL's store them relative to a certain default location,
> don't store complete URL's in the database:
>
> So don't store
> http://www.tribeworks.com/project_2343/Media/Pictures/PICT_023432.jpg
>
> But only something like PICT_023432.jpg because you know all the rest is at
> the same location.
Yes, this is good advice.
--
Best regards,
Ruslan Zasukhin
-------------------------------------------------------------
Paradigma.
e-mail: ruslan@paradigmasoft.com
web : http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on AT lists .DOT macserve.net
-------------------------------------------------------------
©2002 Ruslan Zasukhin |
