 Re: DownloadingSybase ASE 12.5 for Linux
|
Brahma Devlok |
|
4/18/2009 2:25:07 AM |
Maya, Looks nice. Where's the prices for the Linux versions? I've looked all over their site and saw every platform except Linux. I want to know how much it will cost to run on thi
s server (Liunux 6.1).
Post Comments |
|
Re: It is buried in there somewhere. |
Maaya Viswam |
|
4/18/2009 2:25:57 AM |
It is buried in there somewhere.
Remember 11.0.3 is free if you want it.
11.9.2 this time last year cost us around $12K for 2 CPU internet license and 24/7 suppport.
I think for an I-net license it was like $4500 per CPU and then $4K for 24/7 (which they inflated;
it was $2200 but they have a $4,000 minimum ).
Obviously we're going to wait a bit to upgrade to 12.5 but I'd like to roll 12.5 out with my port of vB2.0 (hope to have a beta up by the 4th).
Post Comments |
|
Re: Is it really free do use for any purpose? |
Brahma Devlok |
|
4/18/2009 2:27:25 AM |
Is it really free do use for any purpose? That sou
nds almost too good to be true. Other than the LIMIT statement are were there any
other big problems you came across when porting? W
hat about things like auto increments and other da
ta types? Did you convert much of the code to trig
gers and procedures or did you just change the SQL
syntax?
Post Comments |
|
Re: Well, you don't get any support for it if it b
reaks but... |
Maaya Viswam |
|
4/18/2009 2:28:37 AM |
Well, you don't get any support for it if it breaks but yes, there is something in life which is free!!
You get 11.0.3 and the client libraries on Linux for 100% free for any use!
Post Comments |
|
Re: I just went to Barnes & Noble and Borders look
ing for a Sybase book. |
Brahma Devlok |
|
4/18/2009 2:30:35 AM |
I just went to Barnes &
Noble and Borders looking for a Sybase book. Would you believe they only had one book between them, and that was an out of date book for v 10 &
11! I guess I'll have to order online and wait for delivery Do you have any recommendations? Is there something similar to the Oracle Press book ( but for Sybase obviously
) I don't need half of the book telling me about database design and crap etc. I want more of a reference type book that highlights the Sybase specific functions. It needs to cover the SQL and the configuration and tuning etc.
Post Comments |
|
Re: You're not going to find very many |
Maaya Viswam |
|
4/18/2009 2:31:38 AM |
You're not going to find very many. However I've never needed one other than the online Sybase books.
On this thread:
http://dbforums.com/showthread.php?s=&threadid=65148
I indicate what I find useful online and as I said the only books I've ever needed are the Sybase-published manuals. I think there are two or three new 12.5 books slated to be released in the next 6 to 12 months.
Post Comments |
|
Re: Sybase doesn't support 3 different text dataty
pes |
Maaya Viswam |
|
4/18/2009 2:30:07 AM |
Sybase doesn't support 3 different text datatypes so they are all 'text'
instead of 'small text'
and the like.
INT( 10 ) AUTO INCREMENT
is now:
NUMERIC( 10, 0 ) IDENTITY
For 2.0 I am pushing everything that I can into triggers and really heavily modifying the code. The current code on FanHome is mainly just making SQL code work and using stored procedures where I can. No triggers.
The only problem you might run into with 11.0.3 is that the session table, if heavily hit, might run into locking problems since it is page-only locking. However it took us 400 users before that happened so it shouldn't be a problem for now. You could always stretch the rows out so that they are 2K and fill up the entire page and then set the max_rows_per_page on the index to 1. That should emulate row level locking.
Post Comments |
|
