Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-23 Thread Chris Travers
Evandro's mailing lists (Please, don't send personal messages to this address) wrote: Yes it is exactly that. I will follow you advice and create a abstraction layer for the data access that will return the sparse dataset using the standard dataset as input. There is just one thing I disagre

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-09 Thread Tino Wildenhain
Evandro's mailing lists (Please, don't send personal messages to this address) schrieb: Yes it is exactly that. I will follow you advice and create a abstraction layer for the data access that will return the sparse dataset using the standard dataset as input. There is just one thing I disagre

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-09 Thread Evandro's mailing lists (Please, don't send personal messages to this address)
Yes it is exactly that. I will follow you advice and create a abstraction layer for the data access that will return the sparse dataset using the standard dataset as input.   There is just one thing I disagree you said it that the performance is not good, right. However, it is practical! Nothing is

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Jim C. Nasby
On Tue, Nov 08, 2005 at 02:14:58PM -0500, John D. Burger wrote: > Evandro's mailing lists (Please, don't send personal messages to this > address) wrote: > > >It has nothing to do with normalisation.? It is a program for > >scientific applications. > >Data?values are broken into column to allow

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread John D. Burger
Evandro's mailing lists (Please, don't send personal messages to this address) wrote: It has nothing to do with normalisation.  It is a program for scientific applications. Data values are broken into column to allow multiple linear regression and multivariate regression trees computations.

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Richard Huxton
Evandro's mailing lists (Please, don't send personal messages to this address) wrote: Sorry, It has nothing to do with normalisation. It is a program for scientific applications. It has everything to do with normalisation. You appear to be pushing application presentation issues into the stru

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Bruno Wolff III
> >>> > >>>Well this screams random arbitrary limit to me. Why does this limit > >>>exist? What ever happened to the holy 0,1,infinity triumvirate? > >>> > >> > >>I guess it eases implementation and there is no reason to go so high > >>on columns either. The limit could even be lower w/o and hurts

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Evandro's mailing lists (Please, don't send personal messages to this address)
Sorry,   It has nothing to do with normalisation.  It is a program for scientific applications. Data values are broken into column to allow multiple linear regression and multivariate regression trees computations.   Even SPSS the most well-known statistic sw uses the same approach and data structu

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Alex Stapleton
On 8 Nov 2005, at 16:06, Scott Marlowe wrote: On Tue, 2005-11-08 at 09:45, Tino Wildenhain wrote: Alex Stapleton schrieb: On 8 Nov 2005, at 12:50, Tino Wildenhain wrote: Evandro's mailing lists (Please, don't send personal messages to this address) schrieb: Hi guys, I would like

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Alex Stapleton
On 8 Nov 2005, at 12:50, Tino Wildenhain wrote: Evandro's mailing lists (Please, don't send personal messages to this address) schrieb: Hi guys, I would like to know if it is possible to have more than 1600 columns on windows without recompiling postgres. I would like to know who on

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Randal L. Schwartz
> "Evandro's" == Evandro's mailing lists (Please, don't send personal > messages to this address) <[EMAIL PROTECTED]> writes: [I would have replied to your personal address, but I'm not about to copy it from a footer.] Evandro's> I'm doing a PhD in data mining and I need more than 1600 c

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Scott Marlowe
On Tue, 2005-11-08 at 09:45, Tino Wildenhain wrote: > Alex Stapleton schrieb: > > > > On 8 Nov 2005, at 12:50, Tino Wildenhain wrote: > > > >> Evandro's mailing lists (Please, don't send personal messages to this > >> address) schrieb: > >> > >>> Hi guys, > >>> I would like to know if it is po

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Tom Lane
Tino Wildenhain <[EMAIL PROTECTED]> writes: > Alex Stapleton schrieb: >> Well this screams random arbitrary limit to me. Why does this limit >> exist? What ever happened to the holy 0,1,infinity triumvirate? > I guess it eases implementation and there is no reason to go so high > on columns eith

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Tino Wildenhain
Alex Stapleton schrieb: On 8 Nov 2005, at 12:50, Tino Wildenhain wrote: Evandro's mailing lists (Please, don't send personal messages to this address) schrieb: Hi guys, I would like to know if it is possible to have more than 1600 columns on windows without recompiling postgres. I w

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Tino Wildenhain
Evandro's mailing lists (Please, don't send personal messages to this address) schrieb: I'm doing a PhD in data mining and I need more than 1600 columns. I got an error message saying that I can not use more than 1600 columns. It is happening because I have to change categorical values to bina

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Tom Lane
"Evandro's mailing lists (Please, don't send personal messages to this address)" <[EMAIL PROTECTED]> writes: > I'm doing a PhD in data mining and I need more than 1600 columns. I don't think so --- consider redesigning your data model instead. For instance, maybe you could combine similar columns

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Richard Huxton
Evandro's mailing lists (Please, don't send personal messages to this address) wrote: I'm doing a PhD in data mining and I need more than 1600 columns. I got an error message saying that I can not use more than 1600 columns. It is happening because I have to change categorical values to binary c

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Evandro's mailing lists (Please, don't send personal messages to this address)
I'm doing a PhD in data mining and I need more than 1600 columns. I got an error message saying that I can not use more than 1600 columns.   It is happening because I have to change categorical values to binary creating new columns. Do you know if oracle can handle it?      -- Evandro M Leite Jr. P

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Tino Wildenhain
Evandro's mailing lists (Please, don't send personal messages to this address) schrieb: Hi guys, I would like to know if it is possible to have more than 1600 columns on windows without recompiling postgres. I would like to know who on earth needs 1600 columns and even beyond? Hint: you can

Re: [GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Richard Huxton
Evandro's mailing lists (Please, don't send personal messages to this address) wrote: Hi guys, I would like to know if it is possible to have more than 1600 columns on windows without recompiling postgres. I don't think so. Are you sure you need more than 1600 columns? That's many more than I

[GENERAL] Beyond the 1600 columns limit on windows

2005-11-08 Thread Evandro's mailing lists (Please, don't send personal messages to this address)
Hi guys,   I would like to know if it is possible to have more than 1600 columns on windows without recompiling postgres.   Regards -Evandro-- Evandro M Leite JrPhD Student & Software developerUniversity of Southampton, UKPersonal website: http://evandro.orgAcademic website: http://www.soton.ac.uk