Переход на четвёрку - Unicode

[Logger]

Цитата:

Сообщение от glibs

Чтож, будем надеяться.

Надежды мало :
http://dynamicsmatters.blogspot.com/...inventdim.html

Цитата:

Anonymous said...
>> Create an Array field InventCondition with three fields Batch, SerialNumber, and Condition

Do you plan to make this fields integer type, not string like in Ax3.0 ?

I think it can minimize size of indexes. Besides, DB perform operations with numbers much faster than with strings.

27 March 2008 00:32:00 PDT


Sven Jochimsen said...
I believe that it would be a hughe performance gain but also a hughe functional loss to only have numbers in all the references.

Plus converting existing data will be an even bigger job :-(

Best Regards
Sven

27 March 2008 09:46:00 PDT

[Alexius]

Для любителей серьезного экстрима и MS SQL 2000 могу предложить попробовать поменять местами varchar и nvarchar

sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
GO
sp_configure 'allow updates', 1
RECONFIGURE WITH OVERRIDE
GO
UPDATE systypes SET name = 'varchar2' WHERE name = 'varchar'
GO
UPDATE systypes SET name = 'varchar' WHERE name = 'nvarchar'
GO
UPDATE systypes SET name = 'nvarchar' WHERE name = 'varchar2'
GO

На первый взгляд работает.

PS. Обкатку это не проходило, за последствия не отвечаю