|
|
| Author |
Message |
|
| Guest |
 Posted: Mon Mar 17, 2008 3:13 am |
 |
|
|
Guest
|
I am playing with the music example that come with erlyweb and I saw
this:
mysql_conn:426: fetch <<"DELETE FROM musician WHERE (id = '5')">> (id
<0.160.0>)
My question is on the type of 'id'. It is defined in the table as an
integer but here it is being used as a string. Isn't this going to be
a performance issue in the future if musician gets very large (mysql
does some auto-type conversion IIRC)? Is this a result of the input
type of the form not being converted back to an integer or is that
what erlydb decided to make the type in its queries?
Thanks
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "erlyweb" group.
To post to this group, send email to erlyweb@googlegroups.com
To unsubscribe from this group, send email to erlyweb-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/erlyweb?hl=en
-~----------~----~----~----~------~----~------~--~---
Post recived from mailinglist |
|
|
| Back to top |
|
| Guest |
| Posted: Wed Mar 19, 2008 9:13 am |
|
|
|
Guest
|
I trying reproducing this but I didn't see the same effect:
4> musician:delete(M).
mysql_conn:426: fetch <<"BEGIN">> (id <0.296.0>)
mysql_conn:426: fetch <<"DELETE FROM musician WHERE ((id = 1))">> (id
<0.296.0>)
mysql_conn:426: fetch <<"COMMIT">> (id <0.296.0>)
What DBMS are you using?
On Sun, Mar 16, 2008 at 8:12 PM, orbitz <orbitz@ezabel.com> wrote:
>
> I am playing with the music example that come with erlyweb and I saw
> this:
>
> mysql_conn:426: fetch <<"DELETE FROM musician WHERE (id = '5')">> (id
> <0.160.0>)
>
>
> My question is on the type of 'id'. It is defined in the table as an
> integer but here it is being used as a string. Isn't this going to be
> a performance issue in the future if musician gets very large (mysql
> does some auto-type conversion IIRC)? Is this a result of the input
> type of the form not being converted back to an integer or is that
> what erlydb decided to make the type in its queries?
>
> Thanks
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "erlyweb" group.
To post to this group, send email to erlyweb@googlegroups.com
To unsubscribe from this group, send email to erlyweb-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/erlyweb?hl=en
-~----------~----~----~----~------~----~------~--~---
Post recived from mailinglist |
|
|
| Back to top |
|
| Guest |
| Posted: Wed Mar 19, 2008 11:44 am |
|
|
|
Guest
|
I'm on MySQL.
I am using the music app created straight from the create_app
function and am going by what the ErlyWeb introduction blog entry
has. I'll play with it some more to make sure I am not making a mistake
On Mar 19, 2008, at 4:11 AM, Yariv Sadan wrote:
>
> I trying reproducing this but I didn't see the same effect:
>
> 4> musician:delete(M).
> mysql_conn:426: fetch <<"BEGIN">> (id <0.296.0>)
> mysql_conn:426: fetch <<"DELETE FROM musician WHERE ((id = 1))">> (id
> <0.296.0>)
> mysql_conn:426: fetch <<"COMMIT">> (id <0.296.0>)
>
>
> What DBMS are you using?
>
>
> On Sun, Mar 16, 2008 at 8:12 PM, orbitz <orbitz@ezabel.com> wrote:
>>
>> I am playing with the music example that come with erlyweb and I saw
>> this:
>>
>> mysql_conn:426: fetch <<"DELETE FROM musician WHERE (id = '5')">>
>> (id
>> <0.160.0>)
>>
>>
>> My question is on the type of 'id'. It is defined in the table
>> as an
>> integer but here it is being used as a string. Isn't this going
>> to be
>> a performance issue in the future if musician gets very large (mysql
>> does some auto-type conversion IIRC)? Is this a result of the input
>> type of the form not being converted back to an integer or is that
>> what erlydb decided to make the type in its queries?
>>
>> Thanks
>>
>>
>>>
>>
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "erlyweb" group.
To post to this group, send email to erlyweb@googlegroups.com
To unsubscribe from this group, send email to erlyweb-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/erlyweb?hl=en
-~----------~----~----~----~------~----~------~--~---
Post recived from mailinglist |
|
|
| Back to top |
|
|
|
All times are GMT
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
|
|
|
Digg It
Del.icio.us
Reddit
Facebook
Stumble Upon
Technorati
