Lionel Bouton wrote:
Daniel Smedegaard Buus wrote the following on 27.11.2006 11:52 :
> I'm trying to speed up my app by caching models so that the SQL server
> gets a lower hit rate.
>
This might seem obvious, but are the memcache servers really running and
listening on these ports? What are the logs telling in development mode
(do you see memcache-client debug messsages)?
Hmm... Sorry, I don't know! How do I find out if the servers are
running?
Here's one from the log (there are no messages matching "memcache"):
Processing ItemsController#show (for 10.10.10.110 at 2006-11-27
11:37:14) [GET]
Session ID: cf1eb549ae1b91820ef4b280148f86a9
Parameters: {"action"=>"show", "id"=>"9780192828606",
"controller"=>"items"}
[4;36;1mItem Columns (0.078000) [0m [0;1mSELECT COLUMN_NAME as
ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType,
IS_NULLABLE As IsNullable, COL_LENGTH('Item', COLUMN_NAME) as Length,
COLUMNPROPERTY(OBJECT_ID('Item'), COLUMN_NAME, 'IsIdentity') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Item' [0m
[4;35;1mSQL (0.016000) [0m [0mSELECT COLUMN_NAME as ColName,
COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, IS_NULLABLE As
IsNullable, COL_LENGTH('Item', COLUMN_NAME) as Length,
COLUMNPROPERTY(OBJECT_ID('Item'), COLUMN_NAME, 'IsIdentity') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Item' [0m
[4;36;1mItem Load (9.375000) [0m [0;1mSELECT TOP 1 * FROM
PolyBook.Item WHERE (PolyBook.Item.Itemnumber = 9780192828606) [0m
Rendering within layouts/items
Rendering items/show
[4;35;1mPublisher Columns (0.000000) [0m [0mSELECT COLUMN_NAME as
ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType,
IS_NULLABLE As IsNullable, COL_LENGTH('Publisher', COLUMN_NAME) as
Length, COLUMNPROPERTY(OBJECT_ID('Publisher'), COLUMN_NAME,
'IsIdentity') as IsIdentity, NUMERIC_SCALE as Scale FROM
INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Publisher' [0m
[4;36;1mSQL (0.000000) [0m [0;1mSELECT COLUMN_NAME as ColName,
COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, IS_NULLABLE As
IsNullable, COL_LENGTH('Publisher', COLUMN_NAME) as Length,
COLUMNPROPERTY(OBJECT_ID('Publisher'), COLUMN_NAME, 'IsIdentity') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Publisher' [0m
[4;35;1mPublisher Load (0.000000) [0m [0mSELECT TOP 1 * FROM
PolyBook.Publisher WHERE (PolyBook.Publisher.PublisherID = 1) [0m
[4;36;1mSeries Columns (0.016000) [0m [0;1mSELECT COLUMN_NAME as
ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType,
IS_NULLABLE As IsNullable, COL_LENGTH('Series', COLUMN_NAME) as Length,
COLUMNPROPERTY(OBJECT_ID('Series'), COLUMN_NAME, 'IsIdentity') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Series' [0m
[4;35;1mSQL (0.031000) [0m [0mSELECT COLUMN_NAME as ColName,
COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, IS_NULLABLE As
IsNullable, COL_LENGTH('Series', COLUMN_NAME) as Length,
COLUMNPROPERTY(OBJECT_ID('Series'), COLUMN_NAME, 'IsIdentity') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Series' [0m
[4;36;1mSeries Load (0.000000) [0m [0;1mSELECT PolyBook.Series.*
FROM PolyBook.Series INNER JOIN PolyBook.SeriesItem ON
(PolyBook.Series.SeriesID) = (PolyBook.SeriesItem.SeriesID) WHERE
((PolyBook.SeriesItem.ChildItemnumber = '9780192828606')) [0m
[4;35;1mAuthor Columns (0.015000) [0m [0mSELECT COLUMN_NAME as
ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType,
IS_NULLABLE As IsNullable, COL_LENGTH('Author', COLUMN_NAME) as Length,
COLUMNPROPERTY(OBJECT_ID('Author'), COLUMN_NAME, 'IsIdentity') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Author' [0m
[4;36;1mSQL (0.000000) [0m [0;1mSELECT COLUMN_NAME as ColName,
COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, IS_NULLABLE As
IsNullable, COL_LENGTH('Author', COLUMN_NAME) as Length,
COLUMNPROPERTY(OBJECT_ID('Author'), COLUMN_NAME, 'IsIdentity') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Author' [0m
[4;35;1mAuthor Load (0.016000) [0m [0mSELECT PolyBook.Author.*
FROM PolyBook.Author INNER JOIN PolyBook.AuthorRankTypeItem ON
(PolyBook.Author.AuthorID) = (PolyBook.AuthorRankTypeItem.AuthorID)
WHERE ((PolyBook.AuthorRankTypeItem.Itemnumber = '9780192828606'))
ORDER BY AuthorRank [0m
[4;36;1mAudienceRangeCode Columns (0.015000) [0m [0;1mSELECT
COLUMN_NAME as ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as
ColType, IS_NULLABLE As IsNullable, COL_LENGTH('AudienceRangeCode',
COLUMN_NAME) as Length, COLUMNPROPERTY(OBJECT_ID('AudienceRangeCode'),
COLUMN_NAME, 'IsIdentity') as IsIdentity, NUMERIC_SCALE as Scale FROM
INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'AudienceRangeCode' [0m
[4;35;1mSQL (0.031000) [0m [0mSELECT COLUMN_NAME as ColName,
COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, IS_NULLABLE As
IsNullable, COL_LENGTH('AudienceRangeCode', COLUMN_NAME) as Length,
COLUMNPROPERTY(OBJECT_ID('AudienceRangeCode'), COLUMN_NAME,
'IsIdentity') as IsIdentity, NUMERIC_SCALE as Scale FROM
INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'AudienceRangeCode' [0m
[4;36;1mAudienceRangeCode Load (0.000000) [0m [0;1mSELECT
PolyBook.AudienceRangeCode.* FROM PolyBook.AudienceRangeCode INNER JOIN
PolyBook.AudienceRangeItem ON
(PolyBook.AudienceRangeCode.AudienceRangeCode) =
(PolyBook.AudienceRangeItem.AudienceRangeCode) WHERE
((PolyBook.AudienceRangeItem.Itemnumber = '9780192828606')) [0m
[4;35;1mEditionType Columns (0.031000) [0m [0mSELECT COLUMN_NAME
as ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType,
IS_NULLABLE As IsNullable, COL_LENGTH('EditionType', COLUMN_NAME) as
Length, COLUMNPROPERTY(OBJECT_ID('EditionType'), COLUMN_NAME,
'IsIdentity') as IsIdentity, NUMERIC_SCALE as Scale FROM
INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'EditionType' [0m
[4;36;1mSQL (0.032000) [0m [0;1mSELECT COLUMN_NAME as ColName,
COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, IS_NULLABLE As
IsNullable, COL_LENGTH('EditionType', COLUMN_NAME) as Length,
COLUMNPROPERTY(OBJECT_ID('EditionType'), COLUMN_NAME, 'IsIdentity') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'EditionType' [0m
[4;35;1mEditionType Load (0.000000) [0m [0mSELECT
PolyBook.EditionType.* FROM PolyBook.EditionType INNER JOIN
PolyBook.EditionItem ON (PolyBook.EditionType.EditionTypeCode) =
(PolyBook.EditionItem.EditionTypeCode) WHERE
((PolyBook.EditionItem.Itemnumber = '9780192828606')) [0m
Completed in 10.29700 (0 reqs/sec) | Rendering: 0.12600 (1%) | DB:
9.65600 (93%) | 200 OK [http://psrv4/items/show/9780192828606\]