on 12/27/01 10:46, diskot123 .at. juno .D.O.T com at diskot123@juno.com wrote:
>> Yes, VarChar size still play important role -- it regulate size of page for
>> file. When you say 504 bytes, page is 1024 bytes. For VarChar[10000] page is
>> 20KB. Since page is smallest atom to read / write from disk size of page will
>> affect performance.
> I've designed the database, and imported the data. The size of the .dat
> file is fine even though I thought it would be high as I'm using
> varchar[504] as you suggested. What is an issue however if the size of
> the index file generated 4.8mb from 4 tables. How is the performance with
> LIKE as opposed to = which requires an index. Can valentina generate the
> index on the fly..and then delete it (automatically), to save the user on
> disk space?
1) LIKE in Valentina is again much faster than e.g. In mySQL, because field
is logical file.
2) I can't say how much LIKE is slower of indexed search.
Test self.
3) I wonder that for you 5MB index is problem...
4) Now, Valentina always need index.
In future it will create delete index on the fly,
Or just do NOT index search in numeric column, as LIKE.
> I may need to do a case insensitive partial match..if I want to do a case
> insensitive match with an index, it seems that I will have to import the
> data again as lowercase, and use the left function.
No, you can create BaseObject as
= Lower(fld)
Then use it for case insensitive search and sort.
No waste of disk space.
> It says valentina supports automatic indexing..does that mean I can set
> the indexed property of fields to false, and still get the benefits of
> indexed fields (again trying to save filesize)?
Valentina will make a field indexed as only you do search on it.
This eat disk space.
> ObjectPtrs seem to work great btw.
>
> Been using Valentina App for a while, is there a windows equivelant?
> (Maybe someone should make one in MC/RunRev).
On windows for now you can use viSQL.exe only.
I hope that in nearest months will be introduced totally new VAPP for
Mac/Win and Linux. IT will be used C++ for development.
--
Best regards,
Ruslan Zasukhin
-------------------------
Paradigma.
e-mail: ruslan .at. paradigmasoft .D.O.T com
web : http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on@lists.macserve.net
©2001 Ruslan Zasukhin |
