Re: Oracle vs Sybase

Alexander Penev wrote:

> Tim Uckun wrote:
>
> > I guess I keyed in on the word MUST in that snip I posted. Rereading the
> > documentation I still think I MUST build an index on the column where
> > the linguistic order is desired. I still don't know if I have to
> > specifically use this index or not.
> >
>
> That's really interesting. Can give me some test data which demonstrates this behavior. I would
> like to test it myself.

Just create a table with one column in it (varchar) and put in two values. "Test" and "test" once you have done this then do a select * from table where columnname="test"

If you get one row then it did not work!

> > Besides I figure oracle can send the data just as fast as jet
> > can right?
>
> I wish you were right;-) Oracle can send the data as fast as the network allows it . Suppose you
> have a table with 1000 recs and a record length of 1000 bytes =1 MB, how long do you need to
> copy a 1mb file from your file server ? ...;-))
> I wish you luck. If you have any questions by the migrating you can ask me. I made a migration
> project access-> oracle8/access a year ago. There are some very interesting bugs in acces (at
> least 97)

Well right now the data is on a network server and is being pulled across the wire anyway. I am hoping that oracle can send it just as fast as jet can read the file but this may be hoping for too much. I am going to be upsizing from access 97 and I am aware of quite a few bugs in it but I sure would be interested in your war stories. Email me direct if you wish. Received on Thu Mar 30 2000 - 00:00:00 CST